Updated First Responder Kit and Consultant Toolkit for December 2019

It’s the hap-happiest season of all. To get the new version:

Consultant Toolkit Changes

When you have to troubleshoot deadlocks, wouldn’t it be nice to get the deadlock graphs all saved off nicely in separate XDL files that you can open with Plan Explorer? Good news! For SQL Server 2012 & newer, The Excel file now has a new Deadlock Summary and Deadlock Detail tabs that show the output of sp_BlitzLock, plus the deadlock graphs are written to separate xdl files. (This does mean there is duplication in the output: there’s a copy of the deadlock graph saved for every query in the deadlock. I can live with that for a first version, though.) Here’s what the output folder looks like:

Consultant Toolkit output folder

Other changes this month:

  • Improvement: on the HA-DR tab, the list of AG replicas is now sorted by AG name, primary first, then the sync replicas first, then by replica name.
  • Plus includes the below updates from the First Responder Kit.

sp_BlitzCache Changes

  • Improvement: @BringThePain = 1 no longer forcibly sets @Top to the max. Instead, it’s used as a confirmation switch as in the other First Responder Kit procs. For example, if you set @SortOrder = ‘all’ and @Top > 10, and you didn’t set @SkipAnalysis = 1, then we require you to set @BringThePain = 1 to make sure you understand that processing will be slow. (#2172)

sp_BlitzFirst Changes

sp_BlitzIndex Changes

  • Improvement: when you run it for table-level details, like sp_BlitzIndex @TableName = ‘Users’, the first result set with the list of existing indexes has a new last column with the drop T-SQL. Useful for rapidly building undo/redo scripts. (#2177)
  • Fix: when saving the output to table, index definitions longer than 4,000 characters were truncated. Changed output table definition to NVARCHAR(MAX) for the Drop_tsql, Create_tsql, and index_definition columns, and cried just a little. (#2183, thanks Helio Lino de Almeida Filho for the bug report.)

SqlServerVersions Changes

  • Improvement: added SQL Server 2019, updated a few versions. (#2181, thanks sm8680 for the bug report and Emanuele Meazzo for the fix.)

sp_DatabaseRestore Changes Awaiting Review

There are two pull requests with improvements, but I’ll be honest: I’m not really qualified to do code review on these because I don’t personally use sp_DatabaseRestore. (I just don’t have a use for it myself since most of my work focuses on performance tuning.) If you can give these authors a hand by testing it and making notes in the Github issues, we can get these merged into the main branch:

For Support

When you have questions about how the tools work, talk with the community in the #FirstResponderKit Slack channel. If you need a free invite, hit SQLslack.com. Be patient – it’s staffed with volunteers who have day jobs.

When you find a bug or want something changed, read the contributing.md file.

When you have a question about what the scripts found, first make sure you read the “More Details” URL for any warning you find. We put a lot of work into documentation, and we wouldn’t want someone to yell at you to go read the fine manual. After that, when you’ve still got questions about how something works in SQL Server, post a question at DBA.StackExchange.com and the community (that includes us!) will help. Include exact errors and any applicable screenshots, your SQL Server version number (including the build #), and the version of the tool you’re working with.

Previous Post
SQL ConstantCare® Population Report: Fall 2019
Next Post
What Should We Change About This Year’s Data Professional Salary Survey?

10 Comments. Leave new

  • Hi Brent,

    Thought I’d say it again… you’re totally awesome for what you do, especially for the Blitz code. Thank you, good Sir!

    Reply
  • Naoufal Touailat
    December 3, 2019 9:14 am

    Your scripts help me a lot in my day to day job. THANK YOU.

    Reply
  • Wayne Donaldson
    December 3, 2019 10:19 am

    Amaaaazeballs! Ta very much.

    Reply
  • Mike McLemore
    December 3, 2019 3:38 pm

    How about another class on using the First Responder Kit? The ones you have seemed to fill up pretty fast, to fast for me to get a seat.

    And thanks for the scripts.

    Reply
    • Mike – sure, we’ve got another one open in February. That’ll be the earliest opening though – my schedule is completely packed for the next few months. See you in class!

      Reply
  • Hey Brent, I must say this is an incredible amount of stuff, really awesome tools. I haven’t used them until now but definitely love to use them from now on. Thanks.

    Reply
  • I try not to clutter the ether with “Me, too” … but, in this case, please accept my most sincere thanks and appreciation.

    “…we wouldn’t want someone to yell at you to go read the fine manual….” I was taught to pronounce it as the “fabulous manual” 8)

    Reply
    • When I got out of the Navy, I had to train myself to use “forgotten manual”. I’m only about 90% there, though.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}