SQL Azure Database Activity Monitor (Using T-SQL)

This script reveals how how to implement a SQL Azure Activity Monitor utilising T-SQL.

As with everything in life, this is a good news, bad news story. The bad news is SSMS does not have Activity Monitor for SQL Azure Database and sometimes with my SQL Azure Developer hat on, I am only allowed access to the SQL Azure Database and not the Azure portal.

The good news is most of the counters are there already buried deep within the bowels of DMVs, Dynamic Management Views.

So, in next to no time I knocked together a script to emulate the Activity Monitor, I thought this would be a great start to build on this and expand it with parts on deadlocking and other such important snapshot information.

Please check out our warranty page.

Leave a Reply