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
Category: sp_WhoIsActive
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 …
Stressing tempdb and Observing Contention In SQL Server
Pssst!
If you landed here from Brent’s weekly links, use this link to get my training for 90% off.
The access is for life, but this coupon code isn’t! Get it while it lasts.
Discount applies at checkout, and you …
Reasons Your Query Is Slow Right Now: A Bad Query Plan Appears
Update Stats, They Said
Okay look, you probably should update stats. At least when you do it, you have some control over the situation.
If you let SQL Server get up to its own devices, you might become quite surprised.…
Reasons Your Query Is Slow Right Now: Blocking, Blocking, Blocking
Lockzilla
Blocking sucks. SQL Server should have used an optimistic isolation level by default.
Sure, writers would still block each other, but think of all the time people could have saved not explaining NOLOCK hints.
- Yes, they still take locks
Troubleshooting Parameter Sniffing In SQL Server With sp_WhoIsActive
THANKS ADAM
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 here. I’m also available …
Underused sp_WhoIsActive capabilities: @delta_interval
Great Ghost
In the last post, we looked at how to see if your query is misbehaving, or if things are running normally.
Note that I didn’t say “good” here. Just normal.
For you.
What Have You Done For
…Underused sp_WhoIsActive Capabilities For Troubleshooting SQL Server: @get_avg_time
Ablazemalls
Look, it’s impressive enough that sp_WhoIsActive works as well as it does. Most people who’ve been using it for a while are familiar with using @get_plans to retrieve query plans, or @get_locks to see locking information. I’m gonna spend …
Lock Promotion In SQL Server Parallel Query Plans
I Don’t Always Talk About Locks
But when I do, it’s usually to tell people they should use RCSI, and then disappear in a cloud of smoke.
Recently I was thinking about lock promotion, because that’s what happens when I …