QP metrics are always captured in the default running group, which is group 1 in each respective database. Use sp_metrics ‘backup’ to move saved QP metrics from the default running group to a backup group. Access metric information using a select statement with order by against the sysquerymetrics view. See “sysquerymetrics view” for details.
You can also use a data manipulation language (DML) statement to sort the metric information and identify the specific queries for evaluation. See Adaptive Server Enterprise Component Integration Services User’s Guide, Chapter 2, “Understand Component Integration Services,” for more information about DML commands.
