sp_whoisactive - syntax example

EXEC sp_whoisactive --@show_sleeping_spids=2,
--@filter = 'DOMAIN\username', @filter_type = 'login', --only this login
--@not_filter = 'IGNORETHISHOSTNAME', @not_filter_type = 'host',  --exclude this host
--@not_filter = 'DOMAIN\username', @not_filter_type = 'login',     --exclude this login
   @output_column_list = '[dd%][session_id][percent_complete][sql_text][blocking_session_id][login_name][host_name][database_name][program_name][start_time][wait_info][cpu%][%]',
   @sort_order = '[start_time] ASC'
--@sort_order = '[sql_text] ASC'