Versions Compared

Key

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

The Top Database Applications report lets you find the applications that are consuming the highest amount of your system resources, such as CPU usage , when run running on a specific database. You can define minimum thresholds for each of these performance metrics and then see which applications match or exceed the selected values. This report requires that you enabled Query Monitoring in the SQL Diagnostic Manager Console and have collected sufficient query data for the specified time period.

Tip

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

When to run this report

You should run the Top Database Applications report on a routine basis, such as every week, to proactively identify potential performance issues that may be caused by third-party applications. You can also use this report to track historic historical performance trends and determine the relationship between third-party application usage and your database performance.

...

Most values on the Top Database Applications report correlate with the related SQL Server metric. However, some metric values represent averages over time. Likewise, a few metric values are based on performance algorithms that use multiple statistics to calculate a more accurate metric.

You can access our 

Newtablink
aliasCustomer Support Portal
urlhttps://idera.secure.force.com/
for more information about the algorithm used to calculate a specific metric.

...

...