Have You Heard The One…
Whenever I’m tuning a long stored procedure, I use sp_HumanEvents to grab query plans and other details about what’s going on.
The thing is… It should be a lot easier than that. Unfortunately, when …
Tag: create index in sql server
What’s The Difference Between Read Committed And Read Committed Snapshot Isolation In SQL Server?
Losing Out
I spend a lot of time talking about this with clients, because so many of them face dire blocking and deadlocking issues across a variety of queries under the Read Committed isolation level, that can be easily solved …
SQL Server Community Tools: The Wrap Up And Combined Link
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 …
SQL Server Community Tools: How I Use sp_BlitzLock
Groovy Baby
I wrote sp_BlitzLock while drinking (okay, drunk) on a plane from Chicago to Seattle with Brent. We were headed to PASS in 2017 to teach a precon that I had to pay $500 to get into.
This might …
SQL Server Community Tools: How I Use sp_BlitzCache
Planning To Fail
Back when the plan cache was the only thing you could look at to find slow queries, sp_BlitzCache was a goldmine.
I spent hundreds of hours writing checks for new and different things, adding features, and beating …
SQL Server Community Tools: How I Use sp_BlitzIndex
Those Days
There are a lot of things I skip over when I look at sp_BlitzIndex. Not because they’re unhelpful, but because they need a lot of context.
Diagnosing index issues is tough, because server uptime, workload variability, and …
SQL Server Community Tools: How I Use sp_BlitzFirst
1 of 3
This post is a pretty easy one, because there aren’t a ton of secret ways to run sp_BlitzFirst.
The big value for this one is you can either:
- Run it to get everything since the server
SQL Server Community Tools: How I Use sp_Blitz
Elder Gods
For the last week of the series, I’m going to talk about the Blitz scripts. On top of using them for a hell of a long time, I’ve done a ton of work on them over the years.…
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 …