No, it wasn’t your imagination – we didn’t have any updates for our tools in May. At least not publicly. Internally we did add some features and fix some things in May, but we’ve also been working on a few other things (like new website!) that delayed the public May updates.
Anyhow, we have a few months’ worth of updates for our FREE sp_Check stored procedures, so here are the June updates. And not only do we have more updates and checks for you, our repos now feature enhanced README files that have even more helpful information as well as a listing of every check in each stored procedure. Yes, really!
We hope these new updates can help make your job even easier, especially at proactively identifying issues. Here are the updates for June 2026, with links to the GitHub repositories where you can download the latest versions.
- CHANGE documentation to say SQL Server 2016 and higher
- ADD servername mismatch check (CheckID 617)
- CORRECT offline listener URL (CheckID 417)
- CORRECT various typos
- ADD check for database not synchronized on a synchronous replica (430)
- ADD check for disconnected replicas (431)
- ADD Connected State to Replica result set
- ADD check for suspect pages detected (504)
- ADD check for automatic page repair activity (506)
- CORRECT check for Seeding Mode
- CORRECT check for Database Owner
- CORRECT check for Database Health Level
- CORRECT check for Physical Memory (114)
- REMOVED some dead parameters
- ADD SQL Agent Offline (CheckID 628)
- ADD URL for VLF check (CheckID 217)
- CHANGE documentation to say SQL Server 2016 and higher
- ADD snapshots with differentials for latency check (CheckID 739)
- EDIT wording used for I/O freeze detection (739)
- CHANGE Importance of I/O freeze detection from 1 to 2 (739)
- CORRECT broken links for Check IDs 210, 211, 212, 213
- CORRECT values for replace and recovery in results of @Mode = 2
- UPDATE to work with Azure MI
- UPDATE include Azure MI backup history for user databases
- UPDATE VLF check to only check online databases (217)
- CORRECT typos in Parameters of @Help = 1
- CORRECT check for failed backups to be more robust (207)
- CORRECT typo in Check ID 206
- REMOVED commented debug code
- UPDATE versions for May 2026 updates
- CORRECT URL for local Administrators (315)
- CORRECT typos in CheckIDs 119, 321, 332, 340
- CORRECT typos in @Help = 1
- CORRECT check for number of error log files (622)
- ADD check for proxies for sysadmin (352)
- ADD check for xp_cmdshell proxy account (353)
- ADD check for logins with IMPERSONATE ANY LOGIN (354)
- ADD check for logins with ALTER ANY LOGIN (355)
- ADD check for Resource Governor used for tempdb in SQL Server 2025 (CheckID 727)
- CORRECT check for @SQLMajorVersion
- ADD check for Engine Edition
- ADD check for Accelerated Database Recovery enabled in tempdb (739)
- ADD constraints for @Size, defaulting to MB
- CORRECT check for Resource Governor used for tempdb in SQL Server 2025 (727)
- CHANGE check for file growth for log file to account for default max (619)
- CHANGE @Mode = 3 to use dynamic SQL and work with Azure Managed Instance
- CHANGE Trace Flag checks to exclude Azure MI (715, 716)