Files

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

Checks in this category

FILE001
Data and Log on Same Disk
High
Data and log files should be on separate disks
Versions : 2012-2025
FILE002
TempDB on System Disk
High
TempDB should not be on the C: drive
Versions : 2012-2025
FILE003
TempDB File Count
High
TempDB should have multiple files (1 per core, max 8)
Versions : 2012-2025
FILE004
TempDB File Size
Medium
TempDB files should all have the same size
Versions : 2012-2025
FILE005
Percentage Autogrowth
Medium
Percentage autogrowth causes fragmentation
Versions : 2012-2025
FILE007
High VLF Count
Medium
High VLF count (>200 to watch, >1000 critical) slows recovery and log backups
Versions : 2012-2025
FILE008
Instant File Initialization
Medium
IFI should be enabled to speed up file operations
Versions : 2012-2025
OPS008
Autogrowth events (7d)
Medium
Counts automatic file growth events (default trace EventClass 92/93) over 7 days; frequent ones cause I/O stalls and fragmentation.
Versions : 2012-2025
OPS009
Small fixed autogrowth increment
Low
Detects files with a fixed growth increment below 64 MB, a source of many growth events and fragmentation.
Versions : 2012-2025
FILE006
Max File Size Limit
Info
Verify maximum file size limits
Versions : 2012-2025