SQL Server Database Old Compatability Level Health Check


Use the Old Compatability Level health check in Mini DBA to review SQL Server Database configuration, metadata, and monitoring signals before they become active alerts.

Screenshot pending: Mini DBA SQL Server Database Old Compatability Level health check screenshot placeholder

Health Check Summary

  • Platform: SQL Server Database
  • Health check category: Informational

What This Health Check Means

This health check looks for version or compatibility drift that can affect supportability, security patching, and feature availability.

Why It Matters

The check turns an operational best practice into a repeatable Mini DBA review item so teams do not rely on memory or occasional manual audits.

What To Do If It Fails

Plan an upgrade or compatibility review, test application behavior in a lower environment, and schedule the change through the normal release process.

Review Workflow

  1. Open the health check result and identify the object, setting, or metric named by the failed check.
  2. Decide whether the condition is intentional, inherited from a legacy system, or caused by recent change.
  3. Validate the fix in a lower environment or during a safe maintenance window when the change can affect plans, storage, or access.
  4. Rerun or refresh the health check after remediation so the Mini DBA health view reflects the new state.

Evidence To Collect

Keep a short note explaining why the check failed, what was changed, who owns the follow-up, and whether an exception was approved.

How To Prioritize It

Prioritize it by blast radius. Fix it quickly when it affects a production workload, a shared server, or a customer-facing service; otherwise place it in the normal improvement backlog with an owner.

Prevention And Ownership

Prevent repeat failures by assigning an owner, documenting the expected configuration, and reviewing the check after upgrades, migrations, or major application releases.

Runbook Use

Add this page to the operational runbook for SQL Server Database environments where the check repeatedly fails. Record local thresholds, approved exceptions, escalation contacts, and the expected review interval so the next administrator can act quickly without rediscovering the same context.

Related Pages