Azure SQL Database: Improving Performance Tuning with Automatic Tuning | Data Exposed: MVP Edition

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.

0:00 Introduction
1:25 Automatic tuning features
3:08 Indexes
3:40 Automatic tuning demo
4:40 When to use this feature
6:30 What indexes should be made

✔️ Resources:

About Denny Cherry:
Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

About MVPs:

📌 Let's connect:


🔔 Subscribe to our channels for even more SQL tips:

#MVPTuesday #AzureSQL #AzureSQLDatabase #AutomaticTuning

[ocolakoglu]

Very nice feature. I will try it tomorrom. Thank you Anna and Denny.