Azure SQL Database "Activity Monitor"

Question

One of my Azure SQL Databases is experiencing very high CPU usage. This is a test database server and is definitely not receiving any traffic so it should be very under-utilised.

Is there any way I can troubleshoot this to find where this load is coming from?

Is there some kind of Activity Monitor for SQL Database?

Answer 1

You want to use SQL Azure Dynamic Management Views. Check out this article for more info to get started: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs