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
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.