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.