ONE TWO THREE FOUR FIVE SIX SEVEN WHO DO WE APPRECIATE?
Appreciate doesn’t rhyme with seven.
Special thanks to @JohnKNess, @jsetliffe, @rabryst, @gdoddsy and @SOlsonFAC for various levels of contribution. I’ve made a $10,000 donation in each of your names to the Erik Darling Home For Little Wanderers. Very thoughtful of me.
- #878 The Irascible Mr. @JohnKNess fixed some things so maintenance plans and jobs that shrink things and are enabled have a higher priority than jobs that are disabled, taking into account last runtime. Pretty cool! Now we can all point and laugh at your shrinkage.
- #968 Adds detection and warning for Index Spools. Only the Eager kind. Why? Paul White said so. Fun fact: He was in a band called The Lazy Spools in high school. I had the XQuery written to add the check for Eagerness, but then my XML Dad Mikael Eriksson suggested an alternative. So I went with it just because. Special thanks to #SQLNEWBLOGGER Joe Obbish for suggesting reasonable thresholds, here.
- #928 PLE may go up, and it may go down. We were only looking for one of those directions. Now we’re looking in both of those directions. Thanks to @TaraKizer for pointing that out!
- #937 If you restarted your server a year ago and created a table a month ago, missing index requests for it may be terribly underrepresented. Like me at AA meetings. Now we take table creation date into account when determining missing index benefit.
- #895 Adds session level wait stats for 2016+ using
sys.dm_exec_session_wait_statsto grab the top 3 waits with >5ms time accumulated.
- #942 Adds a
@Debugoption to print out dynamic SQL. Helpful if you’re me.
- #926 Adds tempdb allocations! So you can see how horrible that is now, too.
- #921 Adds Resource Governor information, for both of you crazy kids out there using Resource Governor. Thanks to @djlaney3 for the idea and code submission!
- This underwent a bit of reconstructive surgery to bring it inline with our ‘coding standards’ (read: I had to look busy one day, so I rearranged a bunch of stuff and made sure all our strings were Unicode). No behavior was harmed during this change.
- #906 Fixes an issue with dynamic SQL around the encrypted backup check. Thanks to @jsetliffe
- #909 Clarified language around backup compression and supported versions. Thanks to @rabryst for showing us the error of our loose-tongued ways.
- #911 Corrects math to determine if Diffs are big or not. Thanks to @gdoddsy and @SOlsonFAC for teaching me math.
- #934 Fixes some weirdness when attempting to search for a specific stored procedure by name
- #933 We are compatible with Azure! At least according to @dcurlewis. I don’t have Azure, so I can’t check. He seems trustworthy, though.
- #968 Same as sp_BlitzCache
sp_AllNightLog and sp_AllNightLog_Setup
- These are new! They’re part of our FauxPaaS project to do our own version of Log Shipping ~AT SCALE~. Since these are net-new, check out the documentation and other posts about them to learn more. I could go on for a month, here.
Install_Core_Blitz and Install-All-Procs
- We’re trying something new! Because we hate opening multiple .sql files as much as you do (because why in the blue ox would SSMS decide to spawn a new window FOR EVERY SINGLE SCRIPT YOU OPEN??), we made it easy. Now you can just open one big script. We use a couple simple
copycommands to do this:
copy /b /y sp_Blitz*.sql Install_Core_Blitz.sqland
copy /b /y *.sql Install-All-Procs.sql, which you can use and modify to create your own version, omitting whatever scripts you don’t want. Lucky you!
Thanks for reading!