Adaptive Server 15.0 allows you to capture query processing metrics, aggregating, per query, the data displayed under set statistics time/io in sysqueryplans. You can access the statistical data from sysquerymetrics, including:
The number of times metrics were aggregated for a given query
Minimum, maximum, and average values for each elapsed time, CPU time, logical I/O cost (LIO), and physical I/O cost (PIO)
For more information, see “Using sysquerymetrics and sp_metrics” and Chapter 5, “Query Processing Metrics” in the Query Processor guide.
