ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Summarizes compression rates.
sa_conn_compression_info ( [ connection-id ] )
None
None
The sa_conn_compression_info procedure returns a result set consisting of the following connection properties for the supplied connection. If no connection-id is supplied, this system procedure returns information for all current connections to databases on the server. Parameters include:
Type A string identifying whether the compression statistics that follow represent either one Connection, or all connections to the Server.
ConnNumber An integer representing a connection ID. Returns NULL if the Type is Server.
Compression A string representing whether or not compression is enabled for the connection. Returns Null if Type is Server, or ON/OFF if Type is Connection.
TotalBytes An integer representing the total number of actual bytes both sent and received.
TotalBytesUncomp An integer representing the number of bytes that would have been sent and received if compression was disabled.
CompRate A numeric (5,2) representing the overall compression rate. For example, a value of 0 indicates that no compression occurred. A value of 75 indicates that the data was compressed by 75%, or down to one quarter of its original size.
CompRateSent A numeric (5,2) representing the compression rate for data sent to the client.
CompRateReceived A numeric (5,2) representing the compression rate for data received from the client.
TotalPackets An integer representing the total number of actual packets both sent and received.
TotalPacketsUncomp An integer representing the total number of packets that would have been sent and received if compression was disabled.
ComPktRate A numeric (5,2) representing the overall compression rate of packets.
CompPktRateSent A numeric (5,2) representing the compression rate of packets sent to the client.
CompPktRateReceived A numeric (5,2) representing the compression rate of packets received from the client.
For information on the properties these values are derived from, see Connection-level properties.