Microsoft Certified: Azure Administrator AssociateMonitor and maintain Azure resourcesHard
A company is migrating several on-premises SQL Server databases to Azure SQL Database. They need to implement a solution to continuously monitor the performance of these databases, specifically focusing on deadlocks and long-running queries, and provide detailed insights for performance tuning. Which Azure Monitor feature, specifically designed for database insights, should they use?
- AAzure Monitor Metrics Explorer
- BAzure Monitor SQL Insights (preview)
- CAzure Monitor Activity Log
- DAzure Monitor Workbooks
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Monitor SQL Insights (preview)
Azure Monitor SQL Insights (currently in preview but a key feature for this use case) provides a comprehensive, out-of-the-box monitoring solution specifically for Azure SQL Databases, Managed Instances, and SQL Servers on VMs, offering deep insights into performance metrics like deadlocks and query execution.
Why the other options are wrong
- A. Metrics Explorer can plot general SQL metrics, but it doesn't offer the rich, specialized insights and pre-built views for detailed performance tuning provided by SQL Insights.
- C. Activity Log tracks management plane operations (who did what, when), not database performance metrics like deadlocks or query execution.
- D. Workbooks can visualize data, but they require underlying data sources and custom configuration; SQL Insights provides pre-built, specialized views.
Azure Monitor SQL Insights
A comprehensive, unified monitoring solution within Azure Monitor for Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines, offering deep performance insights.
- Provides pre-built dashboards for SQL performance.
- Monitors deadlocks, expensive queries, wait statistics, etc.
- Leverages Azure Monitor Logs for data collection and analysis.
Memory trick: SQL Insights, deep dive, deadlocks can't hide, queries come alive.