$ SQL Server Health Check
A quick overview of your SQL Server health. Run the script on your server, paste the output below and get instant insights.
Works on SQL Server 2014 and newer. The script does not modify anything — it only reads.
What does the script check? (30+ parameters) ▼
Server & OS
- SQL Server version & support
- Logical/physical cores
- Power Plan (High Performance)
Memory & CPU
- Total physical memory
- Max/Min Server Memory limits
- Buffer Cache Hit Ratio
- MAXDOP and CTP
Files & Storage
- Data/Log/TempDB locations
- TempDB file distribution
- Log file usage (>80%)
- Instant File Initialization
Databases
- Auto-Shrink and Auto-Close
- Percent-based Autogrowth
- Page Verify (CHECKSUM)
- Query Store status
- Suspect Pages (corruption)
Backups
- Databases without FULL backup
- FULL recovery without Log backup
- Backup Compression Default
- MSDB history cleanup
Security
- Service Account permissions
- SA account status
- Linked Servers (SA usage)
Performance & Agent
- High-impact missing indexes
- Failed SQL Agent jobs (24h)
- Critical Alerts
- Database Mail
Loading script...
Frequently asked questions ▼
Does the script change anything on my server?
No. It only reads system views (sys.*, msdb) and collects the results into a table variable. No settings, objects or data are changed.
Is my data sent anywhere?
No. The pasted output is analyzed in your browser with JavaScript. Nothing is uploaded or stored.
Which SQL Server versions are supported?
SQL Server 2014 and newer, including SQL Server 2016, 2017, 2019, 2022 and 2025, both Standard and Enterprise Edition.
What permissions does the script need?
sysadmin gives the most complete result. With fewer permissions some checks still work, but msdb history, Agent jobs and server settings may come back empty.
How do I copy the output?
In SSMS run the script (F5), click the result grid, press Ctrl+A and Ctrl+C and paste it here. Results to Text (Ctrl+T) output and the Azure Data Studio result grid work too.
What should I do with critical findings?
Start with backups and security, then memory and TempDB settings. Each finding includes a recommendation. If you need help, a full audit is available from dba.ee.