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 databasethis report displays the value for Top Applications By CPU, Top Applications By Reads, and Top Applications By Writes. 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.
...
- 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