Azure SQL Server DBA

Azure SQL Server Database Administration Quick Reference

Question

Which DMV shows recent, fine-grained resource consumption for immediate Azure SQL Database troubleshooting?

Answer

sys.dm_db_resource_stats is a DMV for resource governance in Azure SQL Database, queried in the user database. It returns CPU, data I/O, log-write, worker and memory use as percentages of the compute size's limits. Samples are taken every 15 seconds and kept for about an hour.

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

More Azure SQL Server DBA topic samples