Reputation: 40002
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?
Upvotes: 4
Views: 7250
Reputation: 15850
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
Upvotes: 6