Advanced I/O

The 5 checks in the “Advanced I/O” category of a SQL Server audit: what each one verifies, its severity and the versions covered.

Checks in this category
5
Weight in the score
10
Breakdown by severity
1 critical · 1 high · 2 medium · 1 info

Checks in this category

  • IO003

    I/O Warnings (>15s)

    Critical

    I/O operations exceeding 15 s (error log message 833) — a major storage incident.

    Versions : 2012-2025

  • IO001

    Drive Latency

    High

    Aggregated read/write latency per drive (sys.dm_io_virtual_file_stats) — reveals a slow storage subsystem.

    Versions : 2012-2025

  • IO002

    Slowest Files

    Medium

    Database files with the highest I/O latency (cumulative stalls).

    Versions : 2012-2025

  • IO005

    Pending I/O Requests

    Medium

    OS-level pending I/O requests (sys.dm_io_pending_io_requests) — a real-time sign of storage saturation.

    Versions : 2012-2025

  • IO004

    Top I/O Databases

    Info

    Databases generating the most physical I/O — useful to target optimization and placement.

    Versions : 2012-2025

Other categories

All checks