Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

SQL Server | Home Page | Disk Storage Panel

The Disk Storage panel consists of the following:

Component Description

Databases

Shows the total number of databases in the SQL Server instance.

Tempdb

Shows any alarms Spotlight has raised against the Tempdb database. Green is an indicator of no alarms raised. For more information on Tempdb and Spotlight see the SQL Server | Tempdb Drilldown.

Data Files

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 Auto Grow, 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:

  • the total number of file groups in all databases in the SQL Server,
  • the total number of data files in all databases in the SQL Server,
  • the total size of all data files in all databases in the SQL Server, and
  • the percentage used of all data files in all databases in the SQL Server.

Log Files

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 Auto Grow, 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:

  • the total number of log files in all databases in the SQL Server,
  • the total size of all log files in all databases in the SQL Server, and
  • the percentage used of all log files in all databases in the SQL Server.

Index Fragmentation

Maximum Fragmentation measures the fragmentation of the most fragmented index file on the SQL Server. See also the Index Fragmentation Alarm and Index Fragmentation Status Alarm.

Median Fragmentation Measures the median fragmentation of all large index files on the SQL Server. A large index file is an index file with at least 1000 pages.

Max I/O Stall Time

Represents the I/O activity for database files. It shows the maximum stall 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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating