General Charts (System Performance)

Top 10 Most Frequent DB Queries

This chart displays the top 10 database queries SQL Server had processed most frequently. Each query is represented by a bubble on the chart.

Top 10 Slowest DB Queries

This chart displays the top 10 database queries SQL Server had taken the longest to process. Each query is represented by a bubble on the chart.

Info Displayed on Hover

When you hover over a bubble in a chart, the following information is displayed:

• Query Name - The name of the database query.
• Time Interval - The amount of time for which the database query has been cached in the SQL Server memory. If a database query looks problematic (high Occurrence and Processing Time values), you may want to try recompiling it and replacing the cached version with the newly compiled one.
• Occurrences - The X axis value of the bubble, which represents the number of times SQL Server executed this query. A high value might indicate that this specific query is getting processed too frequently.
• Average Processing Time - The Y axis value of the bubble, which represents the average time it took SQL Server to execute this query. A high value might indicate that this specific query takes too long to process.
• Minimum Processing Time - The shortest time this query has taken SQL Server to execute this query since the time it had been cached in the SQL Server memory.
• Maximum Processing Time - The longest time this query has taken SQL Server to execute this query since the time it had been cached in the SQL Server memory.