Trying to diagnose slow running queries?

Sp_who3 can provide a wealth of information in a single screen.

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 2012

Regarding sp_who2

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.


Stay up-to-date on exclusive technical updates and information. Subscribe to our newsletter »


Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.