Versions Compared

Key

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

The Total in DB Highlights chart shows a general overview of the following metrics:

  • Using CPUInternal Wait - Analyze statements experiencing internal waits.
  • I/O Wait
  • Log Wait
  • OS Wait
  • Internal Wait
  • Lock Wait
  • - Analyze disks and storage devices experiencing high I/O waits.
  • Lock Wait - Analyze current and historical locks.
  • Using CPU - Analyze statements with high CPU consumption.
  • OS Wait - Analyze statements experiencing OS waits.
  • Tempdb I/O Wait - Analyze statements experiencing I/O waits on tempdb.
  • Network I/O Wait - Analyze statements experiencing network waits.
  • Log Wait

This box displays the list of metrics by name and measured by the color-coded bars in the Total in DB column.

Tip
When you move the cursor over any of the rows that are in the Total in DB column, you get a box with the information about the metric belonging to that row.

 

  • - Analyze statements experiencing log waits.
  • Remote Wait - Analyze statements experiencing waits for remote instances.


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

...