iAnywhere.com - sa_performance_statistics system procedure

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 » System Procedures » System procedures

sa_performance_statistics system procedure

Returns a summary of memory diagnostic statistics for all connections when the database server has request timing logging enabled.

Syntax

sa_performance_statistics( )

Result set

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.

Remarks

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' );

Permissions

DBA authority required

Side effects

None

Example

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