Azure SQL Server DBA

Monitoring & Performance, Azure-specific

Question

Azure Monitor metrics versus resource-governance DMVs: when should each drive investigation?

Answer

Metrics provide platform-collected trends, alerting, and cross-resource visualization. Resource-governance DMVs expose database-engine consumption relative to its limits. Use metrics for detection and correlated Azure signals; use DMVs to confirm the constrained resource during live SQL Database or Managed Instance investigation.

This is 6 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples