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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>