All databases
Presents aggregated historical query processing metrics for individual queries from persistent data. In addition to monitoring tables, use performance metrics information from this catalog.
The columns for sysquerymetrics are:
Name |
Datatype |
Description |
---|---|---|
uid |
int |
User ID |
gid |
int |
Group ID |
hashkey |
int |
Hashkey over the SQL query text |
id |
int |
Unique ID |
sequence |
smallint null |
Sequence number for a row when multiple rows are required for the text of the SQL |
exec_min |
int null |
Minimum execution time |
exec_max |
int null |
Maximum execution time |
exec_avg |
int null |
Average execution time |
elap_min |
int null |
Minimum elapsed time |
elap_max |
int null |
Maximum elapsed time |
elap_avg |
int null |
Average elapsed time |
lio_min |
int null |
Minimum logical IO |
lio_max |
int null |
Maximum logical IO |
lio_avg |
int null |
Average logical IO |
pio_min |
int null |
Minimum physical IO |
pio_max |
int null |
Maximum physical IO |
pio_avg |
int null |
Average physical IO |
cnt |
int null |
Number of times the query has been executed. |
abort_cnt |
int null |
Number of times a query is aborted by the Resource Governor when a resource limit is exceeded |
qtext |
varchar(255) null |
Query text |
Copyright © 2005. Sybase Inc. All rights reserved. |