/SQLMorningHealthChecks

Primary LanguagePowerShell

SQLMorningHealthChecks

Supported On-prem Versions: SQL Server 2012 and higher

This script answers the following questions about your SQL Servers.

  1. What is the uptime of each SQL Server?
    1. CRITICAL = < 6 hours
    2. WARNING = > 6 hours and < 24 hours
    3. GOOD = > 24 hours
  2. What is the status of each SQL service (engine, agent, full text, etc)?
    1. CRITICAL = Not running with automatic startup
    2. GOOD = Running
  3. What is the status of each cluster node (AG or FCI)?
    1. CRITICAL = Down
    2. GOOD = Up
  4. What is the status of each database?
    1. CRITICAL = Suspect
    2. WARNING = Restoring, recovering, recoery_pending, emergency, offline, copying, or offline_secondary
    3. GOOD = Normal
  5. What is the status of each Availability Group?
    1. CRITICAL = Not_healthy
    2. WARNING = Partially_healthy
    3. GOOD = Healthy
  6. What is the backup status of each database?
    1. CRITICAL = No FULL/DIFF/LOG, FULL > 7 days and DIFF > 2 days, LOG > 6 hours
    2. WARNING = FULL > 7 days and DIFF > 1 day, LOG > 3 hours
    3. GOOD = Normal
  7. What is the available disk space?
    1. CRITICAL = < 10%
    2. WARNING = > 10% and < 20%
    3. GOOD = > 20%
  8. Are there any SQL Agent failed jobs in the last 24 hours?
    1. CRITICAL = Failed
    2. WARNING = Retry or Canceled
    3. GOOD = Succeeded
  9. What errors appeared in the SQL errorlog in the last 24 hours?
    1. CRITICAL = Errors logged
    2. GOOD = No errors logged

For a full description of how this script works, read the article here.

https://docs.microsoft.com/en-us/archive/blogs/samlester/sql-server-dba-morning-health-checks