10. Monitoring and tuning
This chapter covers different techniques to monitor and tune a SQL database and a managed instance. You will learn how to monitor Azure SQL Databases and managed instances using the Azure portal, dynamic management views (DMVs), and extended events. You will learn how to tune an Azure SQL Database using automatic tuning and Query Performance Insight. You will also learn how 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 or SQL Managed Instance from the Azure portal
- Monitor an Azure SQL Database or SQL Managed Instance using DMVs
- Monitor an Azure SQL Database using extended events
- Implement in-memory technologies ...
Get Professional Azure SQL Managed Database Administration - Third Edition 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.
