Versions Compared

Key

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

...

You can further filter your monitored databases by wait time with waits that exceed a defined Wait Threshold in milliseconds. Use this report to compile a list of databases that used most often or have the heaviest loads, these databases are shown in different tables: Top Databases By Data Size, Top Databases By Data Growth, Top Databases By Reads Per Second, Top Databases By Writes Per Second, and Top Databases By Transactions Per Second.

Tip

You can use % as a wildcard in the Search Value field.

...

  • How is the Worst Performing and Most Frequent Queries information gathered? - Solution #00000412
  • How does SQL Diagnostic Manager gather statistics from monitored SQL Servers? - Solution #00000055
  • How does SQL Diagnostic Manager calculate the reorganization percentage for database tables? - Solution #00000301
  • What does the 'Memory Usage' metric in the Console and Reports represent? - Solution #00002237



Scroll pdf ignore
SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
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

...