The Disk Storage panel consists of the following:
|
|
|
Shows the total number of databases in the SQL Server instance. Shows information on data files, summed for all databases in this SQL Server. The disk icon will "fill up" as the total percentage of all data files in all databases increases. This is the current reserved space in all data files as a percentage of the current size of all data files. Note that all figures in the disk icons are accumulated over all databases so that a Percentage Used figure of around 0% does not necessarily mean all databases have plenty of space left. Also, some files may be configured to AutoGrow, so if this figure is approaching 100%, it does not necessarily mean you are almost out of space. The Databases - Data File Group Space Used alarm or the Databases - Dynamic Data File Group Growths Remaining alarm is raised when any database is running out of space. This disk also contains text that shows:
Shows information on log files, summed for all databases in this SQL Server. The disk icon will "fill up" as the total percentage of all log files in all databases increases. This is the current Log Used space in all log files as a percentage of the current size of all log files. Note that the all figures in the disk icons are accumulated over all databases so that a Percentage Used figure of around 0% does not necessarily mean that all logs have plenty of space left. Also, some files may be configured to AutoGrow, so if this figure is approaching 100%, it does not necessarily mean you are almost out of space. The Databases - Log File Space Used or the Databases - Dynamic Log File Growths Remaining alarm is raised when any database is running out of log space. This disk also contains text that shows:
Maximum Fragmentation measures the fragmentation of the most fragmented index file on the SQL Server. See also the Index Fragmentation Alarm (page 1) and Index Fragmentation Status Alarm (page 1). Represents the I/O activity for database files. It shows the maximum wait time per I/O (in milliseconds) for any database file. A value close to zero indicates that little wait is occurring and a value over 25 indicates that the I/O device is likely to be saturated. |
Databases