A list of all data and log files for the selected database, with issues highlighted.
|What It Shows||Comments|
|Logical file name|
|Type||ROWS or LOG|
|Filegroup||Data files only|
|Physical filename||Highlighted if on the C: drive. This increases downtime if there is an issue with the system drive|
|Max size (MB)|
|Growth||Highlighted 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 files||Log files only. Highlighted in orange if > 30|
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 >