sp_BlitzWho

Forget sp_Who and Activity Monitor:
meet sp_BlitzWho.

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

That’s sp_BlitzWho. Download it in our free First Responder Kit.

How to get support for sp_BlitzWho

The sp_BlitzWho documentation covers additional parameters that will return more results, store the results to a table, and more.

For free interactive support, you’ve got a few good options:

• Talk with us in the #FirstResponderKit Slack channel (if you need a free invite, hit SQLslack.com)
• Post a question at DBA.StackExchange.com and the community (that includes us!) will help. Include the version of sp_Blitz, your SQL Server version number (including the build #), and tag it with sp_Blitz.
• To make code improvements or report a bug, visit the Github issues list and read the Contributing Guide

Want training on this?

In my How I Use the First Responder Kit class, I teach you the most important parameters and how I use them in my day-to-day work.

Once you’ve conquered that, my Fundamentals classes cover index tuning, query tuning, TempDB, running SQL Server in the cloud, and much more.

Want consulting help?

Don’t have time to learn the hard way? I’m here to help with a quick, easy process that gets to the root cause of your database health and performance pains. Learn more, see sample reports, and book a free call with me.