sp_BlitzWho is our open source replacement for sp_who and sp_who2. It has all kinds of really neat-o outputs like how many degrees of parallelism the query is using, how much memory it’s been granted, how long it’s been waiting for memory grants, and much more. If you’re on SQL Server 2016 SP1 or newer, it…
Forget sp_Who and sp_Who2:
sp_BlitzWho tells you what’s really happening.
When you’re trying to troubleshoot a slow query, sp_who and sp_who2 don’t cut it. You need something that shows:
- Execution plans
- Memory grants
- Degrees of parallelism
- And a lot more useful stuff for query performance tuners
How to learn more and get support
Here’s where to catch up with us and the rest of the community members who help build this stuff:
- Read our most recent First Responder Kit blog posts (and the sp_BlitzWho posts are shown below this, too)
- Talk with us in the #FirstResponderKit Slack channel (if you need a free invite, hit SQLslack.com)
- To make code improvements or report a bug, visit the Github issues list and read the Contributing Guide
Don’t have time to learn the hard way? We’re here to help with our quick, easy process that gets to the root cause of your database health and performance pains. Our 3-day SQL Critical Care gets to the root of your SQL Server pains and teaches you how to make your databases faster and more reliable. Learn more, see sample reports, and book a free call with me, Brent.