First Responder Kit

COACH! I dunno, I just like this picture. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1786 – @dallyhorton made a good point: if we’re gonna warn you about Change Tracking, we should tell you which database it’s enabled for. #1791 – Who do DMV queries think they are, blocking each other? Get over yourselves. #1793 – CheckIds shouldn’t be…

How to Troubleshoot Blocking and Deadlocking with Scripts and Tools

November 28, 2018

Deadlocks, Monitoring, sp_BlitzLock

When you need to find which queries are blocking other queries, your decision comes down to when the blocking happened. Is it happening now, recently, or coming up soon? During a live emergency, start with sp_WhoIsActive. Adam Machanic’s excellent free sp_WhoIsActive replaces Activity Monitor, sp_who, and sp_who2, and it’s way more powerful. The documentation is extensive –…

First Responder Kit Release: Fingers Crossed!

October 2, 2018

This is a small release just to make sure you don’t forget about us. We know you’re busy. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1755 – @MisterZeus added a new check for alerts that don’t send information out. I mean, is that even an alert? #1766 – @jadarnel27 added some code to help folks who have a standard (non-sa)…

First Responder Kit Release: What Does A Fish Know About Friday?

August 31, 2018

I know, it seems like just yesterday I was doing one of these releases. But no, it was three weeks ago. You’ve just been drunk for a really long time. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1698 – Now warns you about any SQL Modules that have ANSI_NULLS or QUOTED_IDENTIFIER off. Thanks @MisterZeus! #1719 – @TheUsernameSelectionSucks pointed out…

First Responder Kit Release: A Year From Now These Will All Stop Working On 2008 And 2008R2

August 10, 2018

You think I’m kidding. Time bomb. Boom. Get your upgrade underwear on. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1664 – We’re officially smart enough to not warn people that we’re recompiling our own stored procedures. #1669 – Reworded the stacked instances details. Servers may be installed and not running. #1687 – @josh-simar has servers linked with AD accounts,…

First Responder Kit Release: Like pssdiag, if pssdiag had parents who cared

June 27, 2018

I went to the PFE and guess what he told me? Guess what he told me? He said girl you better try fix those spinlocks too No matter what you do, now run this tool You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1620: @AAvella schooled us on Group Policy registry settings. Someday, we’ll get our act…

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

June 20, 2018

sp_BlitzIndex

sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psychiatrist: it’s just flagging behaviors, and there’s not necessarily anything wrong with being a hoarder, or a workaholic, or a furry. They’re just behavioral traits. Let your freak flag fly. One of the warnings is “Aggressive Indexes,” which means sys.dm_db_operational_stats reports minutes of…

First Responder Kit Release: Just When You Think There’s Nothing New Left To Do

June 4, 2018

First Responder Kit, First Responder Kit Updates

T*m* f*r An*th*r F*rst R*spond*r K*t R*l**s*. All joking aside! A big thank you goes out to a few people this go around: @jadarnel27 for not only contributing a bunch of Super Professional T-SQL, but also for writing a web scraping application to compile a list of current SQL Server versions. @nedotter @ktaranov and Aleksey Nagorskiy for putting together…

First Responder Kit Release: Darn May Showers

April 30, 2018

First Responder Kit, First Responder Kit Updates

There’s usually something that I think is funny in this space. Instead, I’m going to extend my already extensive day of civic duty by letting you know something interesting about jury duty. Sometimes, if you show up when they ask you to, they can make you come back for a second day if they…

First Responder Kit Release: Driving Miss Data

March 29, 2018

Ugh. Bungabase slow. When Grog try count meat, Glug eat meat. Then Grog get hungry and Glug try count meat. Bungalock. Need big head make bungabase fast. You big head? You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1459: A while back, Brent blogged about implicit transactions. In the comments, a smart commenter named Dan pointed…

First Responder Kit Release: SQLBits was pretty awesome but now I have to do work again

February 28, 2018

APRIL FOOLS! IT’S ONLY MARCH FIRST! Tomorrow. Butthead. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1407: @parlevjo2 gave us a check to make sure databases are owned by an existing user. Existence is everything, so I hear. #1416: After existence is probably location. After that is collation. @ktaranov let us know that our collation wasn’t all that. Especially…

First Responder Kit Release: Sunday, Boring Sunday

January 28, 2018

This is a modified limited release. After a few new feature releases, we’re achieving stasis. You can download the updated FirstResponderKit.zip here. There are a couple points from the last release that I really need to emphasize: sp_BlitzCache got some new columns added to the output for tempdb spills. If you want to keep logging it…

First Responder Kit Release: It’s Too Cold Not To Do A Release

January 9, 2018

You look just like a snake when you crawl like a worm. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1310: @CferMN reported quite an odd conversion error! Turns out, division was a better idea than multiplication. #1341: We we missing the newest version of Windows, and we had a broken link. Thanks to @JaySpatzfor letting us know!…

Sizing A New Server? Start With Maintenance.

December 22, 2017

Backup and Recovery, CHECKDB and Corruption, First Responder Kit, SQL Server

dba, sql server

Clientele Most of out customers are on slightly (ahem) older (AHEM) hardware, and they have big questions: How do we know what kind of hardware we need? How do we load test it? How do we know what to change to make it better? The load test question is interesting, particularly because getting a reliable…

Introducing sp_BlitzLock: For Troubleshooting SQL Server Deadlocks

December 19, 2017

Deadlocks, First Responder Kit, sp_BlitzLock

Deadlocks are hard Especially when there are a lot of them. When there are dozens or more, looking at each graph is a pain. I had a script written that parsed out the XML, but really, having a folder full of random scripts is for old people. Like Twitter and reverse mortgages. So I turned…

sp_BlitzQueryStore: A Gentle Introduction

December 7, 2017

Execution Plans, First Responder Kit, Query Store (QDS), sp_BlitzQueryStore, SQL Server 2016, SQL Server 2017

dba, development, performance tuning, sql server

Odds and ends During the precon, we asked how many people were on 2016, how many people were aware of query store, how many people were using it, and how many people were using sp_BlitzQueryStore. About 1/3 of the hands went up at first, then for each successive question, fewer and fewer hands stayed up.…

First Responder Kit Release: Treating Object References Like Object Instances, Man

December 5, 2017

First Responder Kit, First Responder Kit Updates

Object reference not set to an instance of an object. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1281 We’ve lowered the priority of Query Store being disabled. It’s just not as important as the backups you’re not taking and the corruption checks you’re not running. sp_BlitzCache Improvements #1253 Due to an unfortunate copy and paste incident,…

How to Track SQL Server Changes with sp_BlitzFirst

November 22, 2017

First Responder Kit

PowerBI, sp_BlitzFirst

In the First Responder Kit’s Power BI Dashboard, there’s a Quick Diagnosis results area where sp_BlitzFirst takes a guess at why your SQL Server was slow – or in this case, why it suddenly got faster: Logging your work in sp_BlitzFirst’s Quick Diagnosis results (click to zoom) In this case, wait times were bad, and…

Announcing the Free First Responder Kit Power BI Dashboard

November 21, 2017