Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Tables » Diagnostic tracing tables

sa_diagnostic_statement table Next Page

sa_diagnostic_statistics table

The sa_diagnostic_statistics table is owned by the dbo user, and contains a history of performance counters maintained in the server. Each row represents the value of a given performance counter at a given moment in time.

There are two versions of this table: sa_diagnostic_statistics, and sa_tmp_diagnostic_statistics.

Column name Column type Column constraint Table constraints
logging_session_idUNSIGNED INTNOT NULL
connection_numberUNSIGNED INTNOT NULL

logging_session_id    A number uniquely identifying the logging session during which the diagnostic information was gathered.

"time"    The time at which the performance counter value was captured.

counter_id    A number uniquely identifying the performance counter. You can get the name of the property that this counter_id represents using the PROPERTY_NAME function.

type    Indicates whether this is a database, server, or connection statistic. Possible values are 0 for server, 1 for database, 2 for connection, and 4 for external database.

connection_number    In the case of a connection statistic, the connection number from which this property was captured. In the case of an extended database statistic, the file number for the file from which this property was captured. Otherwise, the value is 0.

counter_value    The value of the performance counter.

See also