Skip to content

2025-07-04: Celebrating Your Independence Release

Latest
Latest
Compare
Choose a tag to compare
@BrentOzar BrentOzar released this 04 Jul 14:18
20250704
d791ef5
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

I'mma wax philosophical for a second: I love the open source nature of the First Responder Kit because it lets anybody, anywhere, diagnose database problems faster. If you're a full time employee somewhere today, you owe it to yourself to use the FRK scripts because if you ever switch from one company to another, your employment agreement will probably require that you leave your old scripts behind. (I've actually been involved in a lawsuit where a DBA took his T-SQL scripts to his next job, and got sued for it.)

Someday, I hope you celebrate your own personal independence and get to define your own success, and I hope the First Responder Kit scripts help in some small way.

Anyhoo, if you do live performance tuning of workloads under stress, you'll find a lot of little quality-of-life enhancements in this quarter's release.

To get the new version:

Consultant Toolkit Changes

Updated to this month's First Responder Kit, but no changes to the spreadsheet template.

sp_Blitz Changes

  • Enhancement: add warning for AG replica more than 60 seconds behind. (#3635)
  • Enhancement: add warnings for SQL Server 2025's new database scoped configurations and sys.configurations. (#3646 and #3657)
  • Enhancement: clarify warning text about AD groups in case they're empty. (#3648, thanks Jane Palmer.)
  • Fix: was returning multiple warnings if trace flag 7745 wasn't enabled and Query Store was enabled. (#3627)
  • Fix: exclude model database from Query Store checks. (#3654)

sp_BlitzCache Changes

  • Enhancement: can now do plan cache analysis on read-only secondaries. (#3632)

sp_BlitzFirst Changes

  • Enhancement: add warning for deadlocks happening during the live sample. (#3637)
  • Enhancement: add total thread time to headline news result set. (#3631)
  • Enhancement: move "Avg ms Per Wait" to the left in result sets because it's so useful for troubleshooting storage, CPU, and blocking waits. (#3629)
  • Fix: warnings about restores happening now weren't firing on Amazon RDS. (#3643)

sp_BlitzLock

sp_ineachdb

  • Enhancement: adds new parameters for @is_ag_writeable_copy and @is_query_store_on. (#3651, thanks bwiggin10.)

For Support

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.

What's Changed

New Contributors

Full Changelog: 2025040...2025070

Contributors

BrentOzar, erikdarlingdata, and 2 other contributors
Assets 2
Loading