HOW TO: Report On Aggregate Query Execution Details

Within RockSolid you can report on the aggregate resource usage of long running queries within an environment.

To do this:

  • Navigate to the RockSolid reporting menu via Reports -> RockSolid Reports
  • Choose the Instance or Database level in the report hierarchy
  • Choose the "Query Performance" Report


From the report toolbar you can choose to order queries by

  • Reads
  • Writes
  • Duration
  • CPU


Drill Through

The aggregate report shows the base query excluding any runtime parameter options.  This is useful for determining the highest impact queries within the environment.  To view the detail command executions that have been included in the aggregation click the command name from the aggregate report.  This will drill through to the detail report which lists all the individual command executions.


Have more questions? Submit a request


Please sign in to leave a comment.