Page History
...
Multiple database files as well as files from other databases can potentially compete for space on the same disk. For example, if the data and log files for several databases are on the same disk and the data file of one database expands, the available expansion space for all database files on the disk is immediately reduced.
Access the Databases tab
SQL Diagnostic Manager provides two paths to access the Databases tab. The first access path is Access this view by clicking the appropriate monitored SQL Server instance, and then clicking server and selecting the Databases tab. The second access path is by expanding the Servers tree, and then clicking Databases for the appropriate instance.
Alerts associated with the Databases tab
...
Percentage of the allowable disk space for the database currently used by the sum of data, text, and index. Allowable disk space for the database is calculated by taking into account considering the current currently allocated space, auto-growth settings, and available disk space.
...
Failure to read from or write to the hard disk.
Database Status
Multiple types of Database Status alerts exist.
Index Row hits (Percent)
Number of row hits The number of rows hit that part of a clustered index or an entire non-clustered index returns, providing an indication of indicating index effectiveness.
Log Full (Percent)
Percentage of the allowable disk space for the database currently used by the transaction log. Allowable disk space for the database is calculated by taking the current currently allocated space, auto-growth settings, and available disk space.
...
Percentage of pages that are fragmented in each table in the database.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...