Returns a summary of memory diagnostic statistics for all connections when the database server has request timing logging enabled.
sa_performance_statistics( )
Column name | Data type | Description |
---|---|---|
DBNumber | INT | The ID number of the database. |
ConnNumber | INT | An INTEGER representing a connection ID. Returns NULL if the Type is Server. |
PropNum | INT | The connection property number. |
PropName | VARCHAR(255) | The connection property name. |
Value | INT | The connection property value. |
The sa_performance_statistics system procedure returns a result set consisting of a set of memory diagnostic statistics if the server has been told to collect the information. Recording of memory diagnostic statistics must be turned on the database server prior to calling sa_performance_statistics. To do this, specify the -zt option when starting the database server or execute the following:
CALL sa_server_option( 'RequestTiming','ON' ); |
DBA authority required
None
The following example unloads all performance statistics to a text file named dump_stats.txt:
UNLOAD SELECT CURRENT TIMESTAMP, * FROM sa_performance_statistics() TO 'dump_stats.txt' APPEND ON; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |