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 here.

sp_Blitz Improvements

  • #857 Do you have any idea how much stuff is still in the default trace? Billions of things. We go spelunking in there for people running DBCC commands that are weird, then we yell at you about them.

sp_BlitzCache Improvements

  • #864 Having standards is important. Someday we’ll have some, until then we’ll borrow yours. This puts the Cost column in the same place across all ExpertMode outputs. Thanks @douglane!
  • #860 You don’t care about stuff you don’t care about, and neither do we. This moves checks into version aware buckets so we don’t go looking for problems we can’t find on older versions.
  • #839 Big plans! Well, they’re good for people, but not so good for SQL Server. If you have > 128 levels of XML nesting, they don’t show up in a way we can analyze them. Sorry, Tennessee.
  • #842 Getting stored procedure costs could be awfully slow. This fixes that.

sp_BlitzFirst Improvements

  • Nothing this go around

sp_BlitzIndex Improvements

  • Nothing this go around

sp_BlitzWho Improvements

  • #853 Sometimes SQL isn’t good at math when it gets big numbers. This fixes an issue with that. Thanks to @wScottw for the heads up.
  • #845 We now use READ UNCOMMITTED to do our dirty work. Why? Because it’s dirty.
  • #848 We added a table variable to hold intermediate results from sysprocesses. This makes things faster on busy servers.

sp_DatabaseRestore Improvements

#814 We now do differential restores, too. What’s the difference? Run it and see! Thanks to @digitalohm!

You can download the updated here.

Previous Post
[Video] Office Hours 2017/04/26 (With Transcriptions)
Next Post
First Responder Kit Re-Release: The Hubris Of Titles

2 Comments. Leave new

  • Julien Bodin
    May 2, 2017 4:34 am

    Ça plane pour moi, moi, moi, moi, moi…

  • Tim Hidalgo
    May 5, 2017 2:08 pm

    that digitalohm tho!!! ;D

    thanks for open sourcing the kit, it’s a great way for others to get involved, learn and contribute!


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.