Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Image Added

Alerts associated with the Databases tab

...

Failure to read from or write to the hard disk.

Database Status

 Multiple types of Database Status alerts exist.

...

Number of row hits that part of a clustered index or an entire non-clustered index returns, providing an indication of 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 allocated space, auto-growth settings, and available disk space.

...

Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|  
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|  
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse