First Responder Kit

Home
First Responder Kit

How to Track Performance of Queries That Use RECOMPILE Hints

Last Updated May 26, 2020

Parameter Sniffing, Query Store (QDS), sp_BlitzCache

Say we have a stored procedure that has two queries in it – the second query uses a recompile hint, and you might recognize it from my parameter sniffing session: Transact-SQL CREATE OR ALTER PROC dbo.usp_SearchUsers @Reputation INT AS BEGIN /* Query 1, always the same: */ SELECT COUNT(*) FROM dbo.Users; /* Query 2, recompiles…

Updated First Responder Kit and Consultant Toolkit for February 2020

Last Updated February 18, 2020

Brent Ozar

First Responder Kit Updates

We spent Valentine’s Day removing the bugs from your chocolates. You’re welcome. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers: check your email for the updated version from Gumroad,…

Wanna Learn How I Use the First Responder Kit?

Last Updated February 5, 2020

Brent Ozar

First Responder Kit Updates

My newest class, How I Use the First Responder Kit, has been going great – but there’s a catch. I designed this class as a mix of training and consulting, so I’m giving you advice on your server as we go. Because of that, I can only fit so many people (around 50) per class.…

Updated First Responder Kit and Consultant Toolkit for January 2020

Last Updated January 24, 2020

Brent Ozar

First Responder Kit Updates

A couple of times a year, I disconnect from the Internet to sit down with a planning book, my Epic Life Quest, and my future task list. I spend time making sure my day-to-day tasks are still prioritized right. When I do that, I often find out that I’ve lost focus on a particular task,…

Updated First Responder Kit and Consultant Toolkit for December 2019

Last Updated December 2, 2019

Brent Ozar

First Responder Kit Updates

It’s the hap-happiest season of all. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers: check your email for the updated version from Gumroad, our European distributor Consultant Toolkit Changes…

Writing Diagnostic Queries is Hard Because SQL Server Still Has (Tiny) Bugs.

Last Updated November 19, 2019

Brent Ozar

sp_BlitzIndex

When I first got started working with SQL Server, I assumed it was flawless because it came in a sealed box from a ginormous corporation. I figured they’d tested every edge case, and that there was no way things were gonna go sideways. These days, even though I read CU KB articles and giggle about…

Announcing a New Live Online Class: How I Use the First Responder Kit

Last Updated November 13, 2019

Brent Ozar

Company News, First Responder Kit Updates

During the hands-on labs for my Mastering classes, when I’m answering an attendee question, this kind of thing happens a lot: Attendee: “How would I find the query causing that missing index recommendation?” Me: “Oh, good question – you can use the sp_BlitzCache @SlowlySearchPlansFor parameter. Here’s how it works.” (Does a quick demo) Attendees in…

Updated First Responder Kit and Consultant Toolkit for October 2019

Last Updated October 24, 2019

Brent Ozar

First Responder Kit Updates

This is a pretty doggone big release. There are a lot of improvements to sp_BlitzFirst, sp_BlitzCache, and sp_BlitzWho to prepare for a new release of the First Responder Kit Power BI Dashboard. If you’re using that today, I would strongly recommend updating to this new version of the FRK scripts – they fix a ton…

Updated First Responder Kit and Consultant Toolkit for September 2019

Last Updated September 22, 2019

Brent Ozar

First Responder Kit Updates

This month’s release has a lot of new feature goodness: the Consultant Toolkit can automatically upload the results to Amazon S3, plus sp_BlitzCache adds a new sort order to better catch unparameterized queries burning up CPU, a new warning for selects that are doing writes (other than >500MB spills, which we’ve been warning you about…

Updated First Responder Kit and Consultant Toolkit for August 2019

Last Updated August 30, 2019

Brent Ozar

First Responder Kit, First Responder Kit Updates

sp_DatabaseRestore can now restore to Azure blobs and change the database owner after a restore, and everything else gets bug fixes. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers:…

DBA Training Plan 12: What Query Plans Are In Cache?

Last Updated August 11, 2019

Brent Ozar

DBA Training Plan, Execution Plans, sp_BlitzCache

In the last episode, while talking about the basics of executing queries, I said that SQL Server caches execution plans in memory, reusing them whenever the same query gets executed again. I’ve also talked about the dynamic management views (DMVs) that let you query what’s in SQL Server’s memory. Let’s put those two things together…

Updated First Responder Kit and Consultant Toolkit for July 2019

Last Updated July 3, 2019

Brent Ozar

First Responder Kit Updates

Nothing too dramatic, mostly bug fixes this month. Been pretty quiet on the development front the last couple of months. Some stability is nice around here, eh? To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant…

Updated First Responder Kit and Consultant Toolkit for April 2019

Last Updated April 28, 2019

Brent Ozar

First Responder Kit Updates

This month, lots of improvements and bug fixes, including checking for paused resumable index operations, Evaluation Edition expiration dates, sp_BlitzCache shows the number of duplicated plans for each query, sp_BlitzIndex will skip a list of databases for you, and more. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the…

Which Database is Causing the Problem?

Last Updated April 16, 2019

Brent Ozar

First Responder Kit

Pick a bottle, any bottle (Moet & Chandon) You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first? Here are a few ways you can pick – but keep in mind they may produce different answers, especially when you’ve got several databases that suck,…

Updated First Responder Kit and Consultant Toolkit for March 2019

Last Updated March 21, 2019

Brent Ozar

First Responder Kit Updates

This month, just half a dozen bug fixes, plus a new parameter for sp_BlitzCache to search the plan cache for specific strings. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers:…

Updated First Responder Kit and Consultant Toolkit for February 2019

Last Updated February 20, 2019

Brent Ozar

First Responder Kit Updates

I hereby christen this the Rich Benner Memorial Release. He’s still alive, it’s just that we’ll always remember him for the work he put into this month’s version. (I’m kidding, of course. We won’t remember him. (I’m kidding. Rich will appreciate the humor in that.)) You can download the updated FirstResponderKit.zip here, and Consultant Toolkit customers…

[Video] How to Capture Baselines with sp_BlitzFirst

Last Updated October 15, 2019

Brent Ozar

Monitoring, sp_BlitzFirst, Videos

Everybody tells you to capture baselines – but what exactly are you supposed to capture? Which Perfmon counters matter? How do you track which data files are growing, and which ones are slow? How can you track which queries are using the most resources? All you have to do is install the free, open source…

Updated First Responder Kit with Your January Code Resolutions

Last Updated January 28, 2019

Brent Ozar

First Responder Kit Updates

I have a sneaking suspicion that a bunch of you made New Year’s Resolutions to contribute to open source, because y’all got started with a bang this year. We’ve even got improvements from Microsoft folks for Azure Managed Instances! You can download the updated FirstResponderKit.zip here. sp_Blitz Changes Improvements: skipping checks on Azure SQL DB Managed…

sp_BlitzIndex's new statistics histograms at the bottom

How Should We Show Statistics Histograms in sp_BlitzIndex?

Last Updated January 4, 2019

Brent Ozar

Indexing, sp_BlitzIndex

If you’re a graduate of my free How to Think Like the SQL Server Engine course – and you’d better be, dear reader – then you’re vaguely familiar with DBCC SHOW_STATISTICS. It’s a command that shows you the contents of a statistics histogram. When I’m doing the first two parts of the D.E.A.T.H. Method – (D)eduplicating identical…

Updated First Responder Kit for January 2019: Extraneous Syllables

Last Updated December 26, 2018

Erik Darling

First Responder Kit Updates

Does anyone know what the date really is? I usually don’t, and I often consider how doomed humanity would be if I were the smartest person on the planet during any given era. Anyway, you should go hug someone smarter than you. Unless they have sensory or boundary issues. Or a restraining order against you. Thank…