Sample Header Ad - 728x90

How to get the SQL Server Activity Monitor's output using T-SQL?

10 votes
3 answers
39285 views
Is there any script to get the output just like Activity Monitor? Or Which DMV's can I use to get the output as Activity Monitor displays on the screen? It should be able to display the stored procedure name as well as the statement from the stored procedure which is currently running and the bloking related info as well.
Asked by user118167
Feb 22, 2017, 07:57 AM
Last activity: Apr 30, 2019, 08:03 PM