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
Monitoring an Azure ...
Get Professional Azure SQL Database Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
