Home ET

$ sql-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
1
Run the script on your SQL Server
Copy the script and run it in SQL Server Management Studio or Azure Data Studio
T-SQL · SQL Server 2014+ 
Loading script...
2
Paste the script output here
SSMS: press Ctrl+T (Results to Text), then F5. Select all results, Ctrl+C, paste here. Azure Data Studio: copy the result grid.
Analysis Results