Capacity

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

Checks in this category
9
Weight in the score
8
Breakdown by severity
2 critical · 3 high · 3 medium · 1 info

Checks in this category

  • CAP001

    Disk Free Space

    Critical

    Checks free disk space on volumes hosting SQL files

    Versions : 2012-2025

  • CAP003

    Transaction log full

    Critical

    Critical failure as soon as a log is above 80% with no room to grow: the room it has left, bounded both by its maximum size and by the free space of its volume, no longer covers its next autogrowth (64 MB at least). Once full, every write fails (error 9002). Warning for a log of at least 1 GB filled beyond 85% that can still grow. A small full log that can still grow is not a finding. If a database could not be read, or if the volume of a log filled above 80% was not measured, the check abstains instead of concluding that nothing is wrong; a defect found on the databases that were read is still reported.

    Versions : 2012-2025

  • CAP002

    TempDB Space Usage

    High

    Measures space usage within TempDB

    Versions : 2012-2025

  • CAP004

    Data Files Nearly Full (>90%)

    High

    Detects data files with usage exceeding 90%

    Versions : 2012-2025

  • CAP005

    IDENTITY columns and sequences near exhaustion

    High

    Measures how much of its value range each IDENTITY column and sequence has consumed. Past the type ceiling every INSERT fails with an arithmetic overflow.

    Versions : 2012-2025

  • CAP006

    Transaction log truncation blocked

    Medium

    Identifies, for each database, the cause preventing transaction log reuse. Some causes are transient and normal; others are durable and grow the log until the volume fills.

    Versions : 2012-2025

  • TREND001

    Autogrowth events (7d)

    Medium

    Counts autogrowth events in the last 7 days from the default trace (snapshot).

    Versions : 2012-2025

  • TREND002

    Drive free-space runway

    Medium

    Captures free space on the most-constrained SQL volume (baseline; a days-to-full runway needs 2 audits).

    Versions : 2012-2025

  • TREND003

    Largest databases snapshot

    Info

    Inventories the top-5 user databases by allocated size (baseline for inter-audit growth trending).

    Versions : 2012-2025

Other categories

All checks