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.
Category: sp_WhoIsActive
Underused sp_WhoIsActive capabilities: @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 …