SQL Server

sp_WhoIsActive

July 17, 2017

Find out what’s going in SQL server using sp_WhoIsActive.

##Running with this parameter will return column “sql_command”, which shows queries running with parameter values to troubleshoot slow running queries.

sp_WhoIsActive @get_outer_command = 1

##This will filter on the session

sp_WhoIsActive @filter_type =’session’, @filter = 431

You Might Also Like

No Comments

Leave a Reply