Database | Data Files

A list of all data and log files for the selected database, with issues highlighted.

What It ShowsComments
Logical file name
TypeROWS or LOG
FilegroupData files only
Physical filenameHighlighted if on the C: drive. This increases downtime if there is an issue with the system drive
Size (MB)
Max size (MB)
GrowthHighlighted if set to a percentage, or NONE
Avg read (ms)Data files are highlighted in orange if > 50ms, and red if > 100ms.
Log files are highlighted in orange if > 5ms, and red if > 10ms
Virtual log filesLog files only. Highlighted in orange if > 30

Here is an example showing a couple of issues

The write latency of 52ms is higher than ideal.

The log consists of far too many virtual log files. Shrinking to a minimum size, and then growing it immediately in one operation should reduce the number of VLFs and improve performance.

< Database | Overview Database | Tables >