In this release, sp_Blitz shows some information about clusters and AGs, sp_AllNightLog and sp_DatabaseRestore get some love, and more.
To get the new version:
- Download the updated FirstResponderKit.zip
- Azure Data Studio users with the First Responder Kit extension:
ctrl/command+shift+p, First Responder Kit: Import.
- PowerShell users: run Install-DbaFirstResponderKit from dbatools
- Get The Consultant Toolkit to quickly export the First Responder Kit results into an easy-to-share spreadsheet
Consultant Toolkit Changes
I updated it to this month’s First Responder Kit, but no changes to querymanifest.json or the spreadsheet. If you’ve customized those, no changes are necessary this month: just copy your spreadsheet and querymanifest.json into the new release’s folder.
- Enhancement: now works in any database as long as Ola Hallengren’s scripts are installed in the same database. (#3009, thanks Nick Fotopoulos.)
- Enhancement: there’s a new configuration record to allow data/log files to be moved to the instance’s default directory. (#3046, thanks Dale Hirt.)
- Enhancement: now displays information about clusters and Availability Groups. (#2976, thanks Ragatilao.)
- Fix: xp_regread no longer errors out if registry keys aren’t found. (#2836, thanks ScottL1969 and Andreas Jordan.)
- Enhancement: faster visualization of nonclustered columnstore indexes on wide tables. (#3043, thanks Razvan Socol.)
- Fix: total_forwarded_fetch_count column wasn’t included in the results if you saved the results to a table. (#3053, thanks Pollus Brodeur and Vladimir Vissoultchev.)
- Enhancement: the @StopAt parameter is now a real point in time restore, not just stopping at the transaction log before that point, but going up to that moment in time in the last log backup. (#3038, thanks Daniel van der Meulen.)
Bonus changes: Anthony Green kept the SQL Server versions file up to date, and Konstantin Taranov improved the repo’s readme.md.
When you have questions about how the tools work, talk with the community in the #FirstResponderKit Slack channel. Be patient: it’s staffed by volunteers with day jobs. If it’s your first time in the community Slack, get started here.
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 me!) 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.
Wohoo at the sp_DatabaseRestore enhancement!
Brent – I saw your post about new First Responder tool kit today on Jan 18. I following your links to download. It was the Nov 6 toolkit not the new one. I went to Github and downloaded the Jan 6 version from there and I now see new features in sp_blitz about AG’s.
Sorry about that! Can you be more specific about which links you used to download? Thanks!
I get the same, I used the link https://www.brentozar.com/registered/, then used the link https://downloads.brentozar.com/FirstResponderKit.zip to get the download. When I open the zip file all the SQL scripts have a modified date of November 2021
I solved the issue by opening an in private window and then using the https://downloads.brentozar.com/FirstResponderKit.zip to download the fiel
I’ve run into the same issue with the download (getting the 11/6/2021 version). I used the link in the First Responder Kit email: https://downloads.brentozar.com/FirstResponderKit.zip.
I’ve checked repeatedly, and the file is the new version. Your company might have caching software in use at the firewall layer, perhaps.
If you update the FRK using dbatools, be sure to add the -Force parameter!
If you don’t, you risk to install a cached version (that’s what happened to me at least)
Also double check the version inside the stored procedures to be 100% sure!
sp_Blitz Changes broke MS SQL 2008 support.
Hi. Check out the last section on how to get support. Thanks!