In case of disk failure, corruption or ransomware, you risk losing data with no way to restore it.
25 check(s) not applicable to SQL Server 2016 — Details at the end of the report.
Translated into business language, ranked by stakes. Risk is expressed as a level (High / Medium / Low) and an effort, with no financial figure.
In case of disk failure, corruption or ransomware, you risk losing data with no way to restore it.
A security gap can allow theft or leakage of your customer and business data.
If your service continuity isn't guaranteed, an outage can halt your operations for hours or days.
Unsuitable settings can undermine the stability, security or performance of your database.
If files or media are stolen, the data stays readable and GDPR compliance is not ensured.
Neither gaps nor passes: a not-applicable check does not exist on this version or edition, or examines a feature the instance does not use; a not-evaluated check could not be read (rights, network, missing data).
| Check | Title | Reason |
|---|---|---|
| AG012 | REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT misconfigured | SQL Server version |
| AG027 | Contained availability group system databases | SQL Server version |
| DATA001 | Sensitive data classification applied | SQL Server version |
| DATA002 | Likely PII columns not classified | SQL Server version |
| DATA004 | UNMASK granted narrowly | SQL Server version |
| DATA007 | Always Encrypted enclave/attestation | SQL Server version |
| DATA008 | Ledger enabled (integrity required) | SQL Server version |
| DATA009 | Ledger digest verification | SQL Server version |
| DBLVL006 | VECTOR data type inventory (SQL Server 2025) | SQL Server version |
| DBLVL007 | Native JSON data type inventory (SQL Server 2025) | SQL Server version |
| DBSET010 | PREVIEW_FEATURES enabled on a database (SQL Server 2025) | SQL Server version |
| DBSET011 | Accelerated Database Recovery (ADR) disabled | SQL Server version |
| PERF009 | Optimized locking not enabled (SQL Server 2025 - recommendation) | SQL Server version |
| POST001 | CLR strict security (inventory) | SQL Server version |
| POST003 | Trusted assemblies tracked | SQL Server version |
| QOPT004 | PSP optimization disabled (2022) | SQL Server version |
| QOPT006 | DOP/CE feedback disabled (2022) | SQL Server version |
| QS007 | QS Wait Stats capture | SQL Server version |
| SEC022 | External REST invocation enabled (external rest endpoint enabled) | SQL Server version |
| SEC023 | External AI runtimes enabled (external AI runtimes enabled - local ONNX) | SQL Server version |
| SEC024 | External AI models declared (sys.external_models - outbound data flows) | SQL Server version |
| SEC025 | Server-scoped credentials allowed (allow server scoped db credentials) | SQL Server version |
| SURF016 | CLR strict security enabled | SQL Server version |
| TDB003 | Memory-optimized TempDB metadata | SQL Server version |
| TDB005 | XTP growth (HkTempDB) in TempDB | SQL Server version |