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

See also
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;