Enabling Azure SQL Database Auto-Tuning at Scale for Microsoft IT


This is a really exciting episode for people that are using Azure SQL Databases – or anyone that’s looking at migrating on premise or SQL on IaaS to Azure SQL Database. Lyle Dodge talks with Rajesh Vasireddy, a Program Manager in Microsoft IT who has been working with the Azure SQL Database product group for the past few years on the Azure SQL Database Advisor engine. Rajesh has been enabling auto-tuning of database indexes across thousands of servers in Microsoft IT (and way more databases) to allow the Azure SQL Database engine itself to CREATE and DROP indexes across all of our SQL Azure database instances – regardless if they’re running production, dev or test workloads.

The auto tuning feature allows you to let the platform implement the scientifically calculated, tailored recommendations that will significantly enhance the user’s business experience and consume resources optimally. There are safeguards built into the auto tuning system to detect regression and revert implemented recommendations, and avoid going over resource utilization thresholds. Learn more: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-advisor


Duration: 12:32
Publisher: Microsoft Azure
You can watch this video also at the source.