QP metrics are always captured in the default 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 Chapter 2, “Understand Component Integration Services,” in the Component Integration Services Users Guide, which is part of the Adaptive Server Enterprise documentation set. .
