Trying to diagnose slow running queries?
Sp_who3 can provide a wealth of information in a single screen.
Usage:
exec sp_who3
exec sp_who3 active
exec sp_who3 blocked
exec sp_who3 72 /*Any active spid*/
Download: SQL 7 / SQL 2000 / SQL 2005 – SQL 2017
Regarding sp_who3
It’s important to note:
- When using no parameter the output will match the output of sp_who2.
- When using the “active” keyword the output will match the output of sp_who2 active.
- When using the “blocked” keyword the output will have the same columns as sp_who3 active but show only the blocking and blocked processes.
This application is absolutely free.