It’s been very humbling to get so much encouraging feedback about our sp_Check tools from so many of you, especially for our latest tool sp_CheckAG. What started with a new security check tool (sp_CheckSecurity) has grown to four publicly released tools (including sp_CheckBackup and sp_CheckTempdb) that can help SQL Server professionals with both troubleshooting and proactive database administration. And we don’t just make these tools – we use them ourselves!
It’s been a while since we have updated some of these tools, so we have reviewed a lot of outstanding issues. We’ve also been working on pending enhancements, and now have updates for each of the tools. Moreover, there are more updates on the way soon, as we are planning for a more frequent cadence of updates.
Also, I’ll let you in on a little secret: there are more sp_Check tools on the way. We have a few additional stored procedures we have been testing internally that should be ready for public release in the coming months. We’re really excited not just for the new tools, but also for the future feature updates to the current tools.
For now though, we hope these new updates can help you even more. Here are the updates for February 2026, with links to the Straight Path GitHub repository where you can download the latest versions.
- CORRECT logic to determine if SQL Server service account is in sysadmin (CheckID 199)
- CHANGE redundant #TraceFlag and #TraceFlags table usage to only use one table
- CHANGE version to new “year.month” notation
- CORRECT sysname variable declaration to avoid case-sensitivity errors
- CORRECT typos in CheckIDs 110, 408, 409, 413, 415
- CHANGE version to new “year.month” notation
- CORRECT case used in restore history to avoid case-sensitivity errors
- CORRECT check for “A permanent Backup Device” in backup history
- CORRECT typos in CheckID 201, 203, 204, 205, 206, 211, 214
- CORRECT @Help documentation to indicated @Mode = 99 is default
- ADD SQL Server 2025 to #SQLVersions table
- ADD check for most recent security update for 2025
- CHANGE version to new “year.month” notation
- CORRECT sysname variable declaration to avoid case-sensitivity errors
- CORRECT Extended Protection check (CheckID 348)
- CORRECT typos in CheckIDs 301, 302, 303, 304. 350, 801
- ADD check for encrypted tempdb database (CheckID 351)
- ADD check for max size of tempdb files (CheckID 619)
- ADD @VersionCheck
- CHANGE version to new “year.month” notation
- CHANGE default for @AvgReadStallMs from 20 to 100
- CHANGE default for @AvgWriteStallMs from 20 to 100
- CORRECT typo in CheckID 605
- CORRECT typo in CheckID 716
- CORRECT case used for wait_type to avoid case-sensitivity errors
- CORRECT sysname variable declaration to avoid case-sensitivity errors
- CORRECT check for uneven data file growth rates (CheckID 709)
- CORRECT check for memory-optimized tempdb (CheckID 717)