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