From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Configure database automatic tuning

Configure database automatic tuning

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Configure database automatic tuning

“

- Welcome back. This is lesson 9.4 configured database automatic tuning. Automatic tuning is a feature in Azure SQL Database that is designed to provide optimal performance in your database. It does this through continuous performance tuning based on AI and machine learning. It is continuously monitoring your queries in your database and will apply a recommended index, or even remove an index, to improve performance. An automatic tuning can be configured two ways. In the Azure portal, you can configure it at the server level and at the database level. When configured at the server level, every database will inherit, by default, the server level settings, but you can override that at the database level if you have the permissions to do so. With T-SQL, you can use T-SQL to configure automatic tuning at the database level, but not at the server level. So automatic tuning is continuously monitoring the performance of your database and will generate index recommendations whether to create…

Contents