Chapter 9. Monitoring and Tuning Azure SQL Database
This chapter teaches you different techniques to monitor and tune an Azure SQL database. You will learn to monitor an Azure SQL Database using the Azure portal, Dynamic Management Views ( DMVs), and Extended Events.
You will also learn how to tune an Azure SQL Database using Automatic tuning and Query performance insight.
You will learn to implement in-memory features to improve workload performance.
By the end of this chapter, you will be able to:
Monitor and tune an Azure SQL Database from the Azure portal
Monitor an Azure SQL Database using Dynamic Management Views
Monitor an Azure SQL Database using Extended Events
Implement in-memory technologies to improve database performance