From the course: Data Management Essential Training

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Practical example of Azure SQL Server automatic tuning

Practical example of Azure SQL Server automatic tuning

From the course: Data Management Essential Training

Start my 1-month free trial Buy for my team

Practical example of Azure SQL Server automatic tuning

“

- [Instructor] In the previous video, we talked about intelligent database management systems and how that is a future trend that data management is experiencing because of ai. Well, Microsoft and other companies are already starting to integrate this into their products, both on-prem and in the cloud. If we head over to the Microsoft Docs on automatic tuning, you can see that they state that automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and automatically improve their performance. The rest of these docs explain how it works, and that's pretty fascinating. I would highly recommend reading through them. Let's head over to the Azure portal now and look at how this works for Azure SQL databases. Here you can see my Azure SQL server called SQL Server dash LinkedIn dash prod. This is the overview pane, and so you can see all the basic information, including that there is one…

Contents