Summarizes communication compression rates.
sa_conn_compression_info( [ connidparm ] )
connidparm Use this optional INTEGER parameter to specify the connection ID number.
Column name | Data type | Description |
---|---|---|
Type | VARCHAR(20) | Returns a string identifying whether the compression statistics that follow represent either one connection (Connection), or all connections to the server (Server). |
ConnNumber | INTEGER | Returns an INTEGER representing a connection ID number. Returns NULL if the Type is Server. |
Compression | VARCHAR(10) |
Returns On or Off to indicate whether communication compression is enabled on the connection. Returns NULL if the Type is Server, or ON/OFF if the Type is Connection. |
TotalBytes | INTEGER | Returns an INTEGER representing the total number of actual bytes both sent and received. |
TotalBytesUnComp | INTEGER | Returns an INTEGER representing the number of bytes that would have been sent and received if compression were disabled. |
CompRate | NUMERIC(5,2) | Returns a NUMERIC (5,2) value 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 | NUMERIC(5,2) | Returns a NUMERIC (5,2) value representing the compression rate for data sent to the client. |
CompRateReceived | NUMERIC(5,2) | Returns a NUMERIC (5,2) value representing the compression rate for data received from the client. |
TotalPackets | INTEGER | Returns an INTEGER representing the total number of actual packets both sent and received. |
TotalPacketsUnComp | INTEGER | Returns an INTEGER representing the total number of packets that would have been sent and received if compression was disabled. |
CompPktRate | NUMERIC(5,2) | Returns a NUMERIC (5,2) value representing the overall compression rate of packets. |
CompPktRateSent | NUMERIC(5,2) | Returns a NUMERIC (5,2) value representing the compression rate of packets sent to the client. |
CompPktRateReceived | NUMERIC(5,2) | Returns a NUMERIC (5,2) value representing the compression rate of packets received from the client. |
If you specify the connection ID number, the sa_conn_compression_info system procedure returns a result set consisting of compression properties for the supplied connection. If connidparm is not supplied, this system procedure returns information for all current connections to databases on the server.
Cloud note: Because of tenant database isolation rules, when this system procedure is run in the cloud it returns only information about the current tenant database.
None
None
The following example uses the sa_conn_compression_info system procedure to return a result set summarizing compression properties for all connections to the server.
CALL sa_conn_compression_info( ); |
Type | ConnNumber | Compression | TotalBytes | ... |
---|---|---|---|---|
Connection | 79 | Off | 7841 | ... |
Server | (NULL) | (NULL) | 2737761 | ... |
... | ... | ... | ... | ... |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |