EXEC dbo.sp_who
or
EXEC dbo.sp_who2
These are the typical commands where who2 is a newer version that gives us some more info.
who2 tells us the SPID of any blocking process and we can then run,
DBCC INPUTBUFFER(put SPID here)
to tell us what it was doing.
But better than that...
A cool free command written by Adam Mechanic called sp_WhoIsActive
It has some parameters you can switch on but be careful about running this with all execution plans being returned on a busy server.
No comments:
Post a Comment