This stored proc isn’t glamorous, but it calculates your current worst-case for Recovery Point Objective and Recovery Time Objective, which are also performance metrics too:
When you wanna know which queries are running right now, sp_WhoIsActive is pretty much the world standard. However, there are some situations where you need to jump back in the past and troubleshoot complex issues like memory grants. I show how to use both sp_BlitzWho and sp_WhoIsActive for real time troubleshooting, plus set up an…
Deadlocks go bump in the night, and they’re kinda mysterious. Your monitoring app or developers might have been warning you about them, but nobody’s really sure what to do about ’em, or what code to look at. We’ll use sp_BlitzLock for analysis help to figure out what queries & tables need to be changed. In…
Index tuning is the fastest way to make queries go faster without buying hardware or spending time in development. Indexing is as much an art as a science, though: there are a lot of vague guidelines, and sometimes you have to break those guidelines in order to get better performance. sp_BlitzIndex is about analyzing your…
If I could only pick one script in the First Responder Kit to use for the rest of my life, it would probably be sp_BlitzCache. You could just run it as-is with no parameters and learn a lot, but it’s even better now that you’re armed with an understanding of your server’s top wait types….
I know, I know, the name sp_BlitzFirst sounds like it should be the first query that I would run – and it is, when I’m doing emergency performance troubleshooting. That’s not what we’re doing here, though. Here, we’re using it as part of a bigger process to check our server’s wait stats. I’ll talk about…
When you’re first approaching a SQL Server, start with sp_Blitz. We’ll cover my favorite parameters and what I look for in the results, and then start building our notes in Markdown for our eventual health check recommendations for the rest of our team.
Oops! In the last module, while tuning a query, I accidentally cleared the plan cache with DBCC FREEPROCCACHE. Normally, that would be a huge problem for performance tuning – but thankfully, I’m logging sp_BlitzFirst and sp_BlitzCache to tables every 15 minutes in the lab. I show you how to jump back in time and grab…
What if you’re dealing with a database that already exists, and you need to make it go faster with the minimum changes possible? You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how. Part 1 (19 minutes): Part 2 (51m):
