ENDEFRCSIT
Book a health check
Free SQL Server check-up

How healthy is your SQL Server? Find out in 5 minutes.

Run a read-only script, paste the result and get a 0 to 100 score with problems ranked by severity, explained in plain language with the command to fix each one.

  • Read-only script
  • Your data never leaves your computer
  • Free, no sign-up
1

Download and run the script

Open it in SSMS or Azure Data Studio and press Execute. It only reads configuration and system statistics: it never touches table data and changes nothing. Requires SQL Server 2016 SP2 or later.

Download the .sql script
See what the script does

        

        
2

          
Paste the result

          
Copy the «result» cell and paste it here. The analysis runs in your browser: nothing is sent to a server.

          
          
          

          
        

      

      
    

    

      
Want to go beyond the check-up?

      

      
    

    

      
What the script checks
More than 30 automatic checks on the issues that most often cause slowness, data loss and security problems.

      

        
CONFIG
Configuration and performance
  • Version and end-of-support dates
  • Max server memory
  • MAXDOP and cost threshold for parallelism
  • tempdb data files
  • Memory pressure (page life expectancy)
  • High-impact missing indexes
  • Top wait statistics
  • Free disk space

        
SAFETY
Backups, integrity and security
  • Last full and log backup
  • DBCC CHECKDB integrity check
  • Auto shrink, auto close and page verify
  • File growth and log size
  • Failed SQL Agent jobs
  • sa login, sysadmins and password policy
  • xp_cmdshell and TRUSTWORTHY databases
  • Backup compression

      

    

    

      
Questions

      
Does the script change anything or read my data?
No. It only reads system views and the backup history in msdb. It never reads table contents and changes nothing. You can open it and check every line before running it.
Where do the results go?
Nowhere. The analysis runs in your browser: the result is never sent to our servers.
Which versions are supported?
SQL Server 2016 SP2 or later, Standard, Enterprise and Express editions. For older versions or for PostgreSQL, there is the full health check.
How is this different from the paid health check?
The free check runs about 30 automatic tests. The €1,490 health check is done by a senior DBA: 80+ checks, Query Store, Always On, a real restore test, a written report and a walkthrough call.

    

    

      
Want a full review by a DBA?
The fixed-price health check goes beyond automatic tests: in five working days you know what is slow, what is at risk and what to fix first.

        
See the health checkContact