sp_whoisactive of Adam Machanic at GitHub is now support Azure SQL DB
sp_whoisactive is a very helpful monitoring sp used by almost ever SQL Server DBA. It was written by Adam Machanic.
It provide a lot of data showing what is running in your server and the resources being consumed.
Adam & his great team have saved us many hours of work - Thank you Adam!!!
I have been waiting for many years for this SP to be compatible with SQL Azure.
In previous versions when we tried running it on Azure SQL DB we got this error:
"Msg 40515, Level 15, State 1, Procedure sp_WhoIsActive, Line 16 [Batch Start Line 7]Reference to database and/or server name in 'msdb.dbo.sysjobs' is not supported in this version of SQL Server." on (v10.76)
In the SP it called MSDB and since we do not have MSDB in SQL Azure we got the error.