sa_performance_statistics system procedure

sa_performance_statistics( )

Column name	Data type	Description
DBNumber	INTEGER	Returns the ID number of the database. Returns NULL if the property type is Server.
ConnNumber	INTEGER	Returns the connection ID (a number) for the current connection. Returns NULL if the Type is Server or Database.
PropNum	INTEGER	Returns the property number.
PropName	VARCHAR(255)	Returns the property name.
Value	INTEGER	Returns the property value.

The sa_performance_statistics system procedure returns a result set consisting of a set of performance statistics. The results are a subset of the results you can return using the PROPERTY, DB_PROPERTY, and CONNECTION_PROPERTY functions.

You must have the MONITOR system privilege.

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;

sa_performance_statistics system procedure

Syntax

Result set

Remarks

Privileges

Side effects

See also

Example