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

...

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.



Legal
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
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources