I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode
paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who
, sp_who2
etc...
Can anyone explain what, if any difference there is between the two. They seem to show the same thing, albeit with a slightly different set of columns. Also, BlitzFirst shows some other information in it's output as a separate output table
In this video, Brent shows his triage process in which he uses both sp_WhoIsActive
and sp_BlitzFirst
which makes me think there must be some difference but unless I missed something in the video I can't see why sp_WhoIsActive
is required