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.
Note: The size of the bubble is defined by the variation between the Maximum and the Minimum time taken to process the given database query. Therefore, the larger the bubble, the larger the difference, and the more chance that this query is problematic.