Azure SQL Database: Improving Performance Tuning with Automatic Tuning

%3CLINGO-SUB%20id%3D%22lingo-sub-1927906%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Database%3A%20Improving%20Performance%20Tuning%20with%20Automatic%20Tuning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1927906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20style%3D%22font-size%3A%2011.0pt%3B%20font-family%3A%20'Calibri'%2Csans-serif%3B%20mso-fareast-font-family%3A%20Calibri%3B%20mso-fareast-theme-font%3A%20minor-latin%3B%20mso-ansi-language%3A%20EN-US%3B%20mso-fareast-language%3A%20EN-US%3B%20mso-bidi-language%3A%20AR-SA%3B%22%3EOne%20of%20the%20performance%20benefits%20of%20using%20Azure%20SQL%20Database%20is%20the%20ability%20for%20Azure%20SQL%20Database%20to%20automatically%20add%20and%20remove%20indexes%20from%20the%20database%2C%20based%20on%20the%20workload%20that%20is%20running%20against%20the%20database.%20Join%20Denny%20Cherry%20as%20he%20shows%20you%20how%20to%20enable%20automatic%20tuning%20and%20when%20it%20won%E2%80%99t%20help%20you%20as%20much%20as%20you%20think%20that%20it%20will.%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22font-size%3A%2011.0pt%3B%20font-family%3A%20'Calibri'%2Csans-serif%3B%20mso-fareast-font-family%3A%20Calibri%3B%20mso-fareast-theme-font%3A%20minor-latin%3B%20mso-ansi-language%3A%20EN-US%3B%20mso-fareast-language%3A%20EN-US%3B%20mso-bidi-language%3A%20AR-SA%3B%22%3ETo%20watch%20more%20Data%20Exposed%20episodes%2C%20check%20out%20our%20playlist%20on%20YouTube%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fdataexposedyt%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fdataexposedyt%3C%2FA%3E%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22font-size%3A%2011.0pt%3B%20font-family%3A%20'Calibri'%2Csans-serif%3B%20mso-fareast-font-family%3A%20Calibri%3B%20mso-fareast-theme-font%3A%20minor-latin%3B%20mso-ansi-language%3A%20EN-US%3B%20mso-fareast-language%3A%20EN-US%3B%20mso-bidi-language%3A%20AR-SA%3B%22%3ESubscribe%20to%20our%20YouTube%20channel%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fmsazuresqlyt%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fmsazuresqlyt%3C%2FA%3E%20%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22font-size%3A%2011.0pt%3B%20font-family%3A%20'Calibri'%2Csans-serif%3B%20mso-fareast-font-family%3A%20Calibri%3B%20mso-fareast-theme-font%3A%20minor-latin%3B%20mso-ansi-language%3A%20EN-US%3B%20mso-fareast-language%3A%20EN-US%3B%20mso-bidi-language%3A%20AR-SA%3B%22%3EFollow%20us%20on%20Twitter%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fazuresqltw%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fazuresqltw%3C%2FA%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1927906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eazure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

One of the performance benefits of using Azure SQL Database is the ability for Azure SQL Database to automatically add and remove indexes from the database, based on the workload that is running against the database. Join Denny Cherry as he shows you how to enable automatic tuning and when it won’t help you as much as you think that it will.

To watch more Data Exposed episodes, check out our playlist on YouTube: https://aka.ms/dataexposedyt

Subscribe to our YouTube channel: https://aka.ms/msazuresqlyt

Follow us on Twitter: https://aka.ms/azuresqltw 

0 Replies

Session Resources