Operations / guarded automation

SQL Server Autopilot

One control plane for evidence quality, backups, maintenance, reliability, capacity, performance and security signals. Observation is automatic; changes remain reviewable and controlled.

Open priority queue Verify evidence
8.1/ 10
Environment score Gold Generated 2026-09-28 02:23
SQL Server targets55 registered total
Active1full coverage or active with exceptions
4/4 automation1backup, integrity, index, statistics
Critical blockers025 total signals
Evidence coverage100%missing data never scores green
Control areasWhy the score looks like this
Target: 70 or higher in every area
Backup & recovery Fresh restore-chain evidence, not merely a scheduled job.
1000 below target
Maintenance automation Enabled backup, integrity, index and statistics routines.
604 below target
Reliability Connectivity, successful jobs and low runtime error pressure.
655 below target
Capacity Enough measured storage headroom for growth and maintenance.
750 below target
Performance CPU, memory, concurrency and long-running workload signals.
930 below target
Security signals Audit/EventLog coverage and authentication-failure signals.
890 below target
Evidence quality Collector coverage required to avoid false-green conclusions.
1000 below target
Instance control board5 SQL Server instance(s)
7.8/10
SERVER 1Test · TESTSRV_1.DBNEXIA.COM
Guarded
Automation 2/43 app-managed job(s)
Backup Integrity Index Statistics
Evidence 100% Agent inventory current
Backup & recovery
Maintenance automation
Reliability
Capacity
Performance
Security signals
Evidence quality
Next best actionSchedule integrity checks

Use a separate weekly CHECKDB window and verify that it completes for every database.

Administrator approval required
7.9/10
SERVER 3Test · TESTSRV_3.DBNEXIA.COM
Guarded
Automation 2/42 app-managed job(s)
Backup Integrity Index Statistics
Evidence 100% Agent inventory current
Backup & recovery
Maintenance automation
Reliability
Capacity
Performance
Security signals
Evidence quality
Next best actionSchedule integrity checks

Use a separate weekly CHECKDB window and verify that it completes for every database.

Administrator approval required
7.9/10
SERVER 4Test · TESTSRV_4.DBNEXIA.COM
Guarded
Automation 2/43 app-managed job(s)
Backup Integrity Index Statistics
Evidence 100% Agent inventory current
Backup & recovery
Maintenance automation
Reliability
Capacity
Performance
Security signals
Evidence quality
Next best actionSchedule integrity checks

Use a separate weekly CHECKDB window and verify that it completes for every database.

Administrator approval required
8.0/10
SERVER 5Test · TESTSRV_5.DBNEXIA.COM
Guarded
Automation 2/42 app-managed job(s)
Backup Integrity Index Statistics
Evidence 100% Agent inventory current
Backup & recovery
Maintenance automation
Reliability
Capacity
Performance
Security signals
Evidence quality
Next best actionSchedule integrity checks

Use a separate weekly CHECKDB window and verify that it completes for every database.

Administrator approval required
9.0/10
SERVER 2Test · TESTSRV_2.DBNEXIA.COM
Active
Automation 4/43 app-managed job(s)
Backup Integrity Index Statistics
Evidence 100% Agent inventory current
Backup & recovery
Maintenance automation
Reliability
Capacity
Performance
Security signals
Evidence quality
Next best actionReview open recommendations

Automation coverage is complete; work from highest operational impact and verify each result.

Open
Transparent scoringWhat the 0–10 number means
25%Backup & recovery
20%Maintenance automation
15%Reliability
15%Capacity
10%Performance
10%Security signals
5%Evidence quality

Scores are current operational guidance, not a guarantee of availability, compliance or recoverability. Evidence below 50% caps an instance at 5.4, and failed connectivity caps it at 3.0. A successful isolated restore test remains the proof that backups are usable.