Summary

In this chapter, we covered different ways of monitoring and tuning Azure SQL Databases and SQL Managed Instances. We learned how to use Azure SQL Database performance metrics and Query Performance Insight to monitor database metrics and queries from the Azure portal.

The chapter talked about using Azure SQL Analytics to monitor Azure SQL Database and SQL Managed Instance. Intelligent Insights, provided by Azure SQL Analytics, can be used to set up alerts on different metrics such as CPU, log I/O, blocks, and deadlocks for Azure SQL Database. Intelligent Insights can also be used to fine-tune long-running and CPU- or I/O-intensive queries to further optimize an Azure SQL database.

We also learned how to set up alerts on database metrics, and proactively acted as and when alerts were raised. We learned about important DMVs and how to set up extended events to monitor a SQL database or a managed instance.

Following this, we set up automatic tuning for an Azure SQL database...