I am a heading
Over the past month (plus or minus a couple days), I’ve shown you in a series of quick posts how I use different SQL Server Community Tools that are free and open source to troubleshoot SQL …
Category: sp_WhoIsActive
SQL Server Community Tools: How I Log sp_WhoIsActive To A Table
Been There
A lot of the code to do this is in the sp_WhoIsActive documentation.
But since I have to do things a little bit differently, I decided to open source the way I do things.
You can get …
SQL Server Community Tools: Filtering sp_WhoIsActive Results
Oh Baby You
On really busy SQL Servers, or on SQL Servers where some ninny activated Service Broker on hundreds of databases so you have hundreds of sessions constantly sitting there waiting for conversations, being able to filter out stuff …
SQL Server Community Tools: Changing The Output Of sp_WhoIsActive In Different Ways
But Why?
As a procedure, sp_WhoIsActive is pretty perfect. It’s not all things to all people, but it does what it’s supposed to do really well.
One thing I really like about it is that you can change a couple …
SQL Server Community Tools: Using sp_WhoIsActive To Track Down Implicit Transactions
In The Annals
When people talk about bad ideas in SQL Server, implicit transactions are pretty high on the list.
I’ve talked about why in the past, but up until recently sp_WhoIsActive didn’t do much to surface queries using …
SQL Server Community Tools: How To Use sp_WhoIsActive To Get Memory Grant Information
Woah woah woah
Up until now, I’ve written about scripts that I wrote from scratch. But they’re far from the only tools I use in my every day life.
A big one is, and always has been, sp_WhoIsActive. It’s …
Correlating Data From sp_WhoIsActive to Query Store Or The Plan Cache
sp_QuickiePost
If you’re the type of person who logs sp_WhoIsActive to a table to capture executing queries, you may want to find some additional details about the statements that end up there.
Out of the box, it’s arduous, tedious, …
sp_WhoIsActive Version 12 Is Out!
Get’em Daddy
You know, you love it, you often wondered if it would ever get a new version!
…Someone JUST asked me yesterday if this has been updated recently. Thank you for sharing!
— Erin Stellato (@erinstellato) November 10, 2021
I’m Officially A Maintainer Of sp_WhoIsActive!
Busyness, Man
sp_WhoIsActive is probably one of the most famous utilities in SQL Server. To the point where when I see people using sp_who – sp_who4762, I immediately disqualify their ability as a DBA.
If you think that’s unfair, it’s …
Starting SQL: Monitoring SQL Server Queries With sp_WhoIsActive
Starting SQL: Monitoring Active Queries With sp_WhoIsActive
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from …