Versions Compared

Key

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

...

  • Internal Wait - Analyze statements experiencing internal waits.
  • I/O 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 - Analyze statements experiencing log waits.
  • Remote Wait - Analyze statements experiencing waits for remote instances.


Scroll pdf ignore
SQL Workload Analysis add-on provides a granular breakdown of wait states with easy drill-down to isolate problems quickly.
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

...