Database Level

The 7 checks in the “Database Level” category of a SQL Server audit: what each one verifies, its severity and the versions covered.

Checks in this category

DBLVL004
Databases in abnormal state
Critical
Offline, suspect or recovery-pending databases
Versions : 2012-2025
DBLVL005
Old compatibility levels
Medium
Databases with a compatibility level below the engine (missed optimizer improvements)
Versions : 2012-2025
DBLVL001
Database count
Info
Total number of user databases on the instance
Versions : 2012-2025
DBLVL002
Database sizes
Info
Size of the largest user databases
Versions : 2012-2025
DBLVL003
Log space usage (inventory)
Info
Reports, database by database, the transaction logs filled above 80% and the room to grow they have left. Inventory without a verdict: that one is carried by CAP003, which reads the same measurements — counting it twice would penalise a single full log twice.
Versions : 2012-2025
DBLVL006
VECTOR data type inventory (SQL Server 2025)
Info
Per-database, per-column inventory of native VECTOR type usage (2025), with dimensions and base type. Governance visibility: embeddings are large (backup/storage impact), often derived from personal data (GDPR scope), and tied to external AI flows.
Versions : 2025
DBLVL007
Native JSON data type inventory (SQL Server 2025)
Info
Per-database, per-column inventory of native JSON type usage (binary storage, 2025). Governance visibility of 2025 new-type adoption. Note: the native json type is in preview on SQL Server 2025 on-prem, so its presence can correlate with PREVIEW_FEATURES being enabled.
Versions : 2025