We have a job that polls and does exec of the below every 10 minutes, and saves the result into WhoActive table.
The exact call with these parameters is below.
My question is: In what scenarios and how can we query the table WhoActive in the most meaningful way to solve a particular problem or production outage?
Does anyone know where possibly at Brent Ozar's or other sites where certain queries are published that people use to query such repository of spWhoIsActive calls ? Basically, I am trying to figure out why we are saving this info and use Gs of space for this table,? how can we best take advantage of this kind of historical info?
EXEC sp_WhoIsActive @get_outer_command = 1, @get_plans = 1,@find_block_leaders = 1,
@sort_order = '[blocked_session_count] DESC',@destination_table = WhoActive ;
Voldemar likes to play CHESS (and IS good at it!)