First Responder Kit

First Responder Kit Release: Ça plane pour moi

Ah, May. Spring has sprung, and young people’s minds turn towards seasonal allergies. Special thanks to @digitalohm for the Differential Restore code and general sp_DatabaseRestore spiffiness. May you live to an age that can only be described in Unix. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #857 Do you have any idea how much…
Read More

First Responder Kit Release: Now With 100% More Working Code Than The Irish Space Program

Every April I think about this girl I grew up with named April who smelled like Cheez-Wiz. She died tragically in a home for the blind on Taco Tuesday. Special thanks to @jeffrosenberg , @mrthomsmith , @rwhoward for contributing this month. Your complimentary oxygen is now available. The rest of you can go download the First…
Read More
Pocket Square

First Responder Kit Updates: New Checks Across the Board

First Responder Kit
1 Comment
It’s the December to Remember Script Event, and we’ve got updates to everything. Shout out to our contributors this month: @BlitzErik, @RichBenner, @runamuk0, @SQLMonger, and @BrentOzar. Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #591 – add check for 2016 Standard installed without Service Pack 1 (coded by @RichBenner) #615…
Read More
Pocket Square

Updated First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex

These improvements go great with cranberries. The food, not the b – actually, they go pretty well with the band, too. sp_Blitz Improvements #568 – @RichBenner added a check for the default parallelism settings sp_BlitzCache Improvements by @BlitzErik #495 – add warning for indexed views with missing stats #557 – bug fix – don’t alert…
Read More

First Responder Kit Update: sp_BlitzCache Catches Cursors, Scalar Functions, and More

First Responder Kit
7 Comments
Every time we take on a client for our SQL Critical Care®, the very first thing we do is run the First Responder Kit scripts: sp_Blitz to get a health check, sp_BlitzFirst to check their wait stats, sp_BlitzIndex to look at their indexes, and sp_BlitzCache to see the most resource-intensive queries. Very often, these scripts surface…
Read More

Updated First Responder Kit: sp_Blitz markdown output, sp_BlitzIndex statistics checks

In addition to lots of bug fixes and tweaks, my favorite option is: sp_Blitz @OutputType = ‘markdown’ sp_Blitz @OutputType = ‘markdown’, @CheckServerInfo = 1, @CheckUserDatabaseObjects = 1 See, recently I’ve spent a lot of time looking at Stack questions going, “Man, if I just had the output of sp_Blitz, I bet I could answer that question…
Read More

What To Do If sp_BlitzFirst Warns About High Compilations

Compiles Aren’t The Same As Recompiles If you’re seeing high RECOMPILES, this post isn’t for you. We’ll talk about the differences between compiles and recompiles, but not how to troubleshoot recompiles. Recompiles mean one of two obvious things: You have a RECOMPILE hint at the stored procedure or statement level, or SQL found a reason…
Read More

Learn to Use sp_Blitz, sp_BlitzCache, sp_BlitzFirst, and sp_BlitzIndex with These Tutorial Videos

There have been so many improvements lately to our First Responder Kit scripts that it was time to update our tutorial videos. Each of these is about ten minutes long and shows how to use ’em: How to Use sp_Blitz for a Health Check How to Use sp_BlitzCache to Find Slow Queries How to Use…
Read More

First Responder Kit 2016-09: sp_Blitz, sp_BlitzCache, sp_BlitzIndex Improvements

First Responder Kit, SQL Server
0
First, thanks to 5 community volunteers for contributing code this month. In addition to lots of bug fixes, small stuff, and a new Github issue template (thanks, Konstantin Taranov) here’s the big improvements: sp_Blitz Changes @OutputServerName writes output to remote server (Haris Khan) – for years, these stored procs have had an @OutputServerName parameter just waiting to…
Read More