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 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.
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 historical performance trends and determine the relationship between third-party application usage and your database performance.
How SQL Diagnostic Manager calculates metric values on this report
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 Customer Support Portal for more information about the algorithm used to calculate a specific metric.
- 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