Connection Properties

Examples

Use the connection_property system function to retrieve the value of a connection property. The following statement returns the number of pages that have been read from file by the current connection:

select connection_property ( 'DiskRead' )

Use the sa_conn_properties system procedure to retrieve the values of all connection properties.

call sa_conn_properties

A separate row appears for each connection, for each property.