sysprotects  sysqueryplans

Chapter 1: System Tables

sysquerymetrics

All databases

Description

Presents aggregated historical query processing metrics for individual queries from persistent data. In addition to monitoring tables, use performance metrics information from this catalog.

Columns

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

View this book as PDF