My favorite configuration of sp_WhoIsActive is …

EXEC [master].[dbo].[sp_WhoIsActive] @get_plans=1, @get_additional_info = 1
--, @get_task_info = 2
--, @sort_order = '[cpu] desc'
--, @filter_type = 'session', @filter = '2018'
--, @filter_type = 'login', @filter = 'windowslogin'
, @output_column_list = '[dd%][session_id][block%][sql_text][sql_command][login_name][CPU%][wait_info]
[tasks][tran_log%][database%][percent%][Program%][host%][reads%][writes%][query_plan][locks][%]'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s