Lists and describes the key performance indicators (KPIs) that provide the statistics displayed on Sybase IQ screens and charts in Sybase Control Center.
Each Sybase IQ data collection includes a subset of the KPIs listed here.
| KPI | Description |
|---|---|
| Active INC incoming connections | Number of internode communication (INC) incoming connections. |
| Active INC outgoing connections | Number of INC outgoing connections. |
| Active INC transactions | Number of active INC transactions. |
| Active load table statements | Number of active load table statements. |
| Active transactions | Total number of active transactions including user and INC transactions. |
| Active user connections | Number of active user connections. |
| Active user transactions | Number of active user transactions. |
| Available communication buffers | Number of available network communication buffers. |
| Bytes received | Number of bytes per second received during client/server communications. |
| Bytes received uncompressed | Number of bytes per second that would have been received during client/server communications if compression was disabled. |
| Bytes sent | Number of bytes per second sent during client/server communications. |
| Bytes sent uncompressed | Number of bytes per second that would have been sent during client/server communications if compression was disabled. |
| Catalog cache dirty pages percent | Percentage of pages in the catalog cache where data has been modified and stored in the buffer cache and has not yet been written to disk. |
| Catalog cache hits | Number of catalog cache hits per second. |
| Catalog cache size | Current catalog cache size in megabytes. |
| Catalog cache in use percent | Percentage of the catalog cache in use. |
| Catalog cache pinned | Number of pinned catalog cache pages. |
| Catalog cache pinned percent | Percentage of the catalog cache pinned. |
| Catalog cache reads | Number of catalog cache page lookups per second. |
| Catalog store disk reads | Number of kilobytes per second that have been read from the catalog store. |
| Catalog store disk writes | Number of kilobytes per second that have been written to the catalog store. |
| CPU total usage | Percentage of the Sybase IQ server CPU in use, including both system and user usage. |
| CPU system usage | Percentage of the CPU being used by the system. |
| CPU user usage | Percentage of the CPU being used by the users. |
| Dbspace size in use | Amount of space being used in the dbspace, in kilobytes. |
| Dbspace space available percent | Percentage of dbspace available. |
| Dbspace file size in use | Amount of space being used in the dbspace file, in kilobytes. |
| Dbspace file space available percent | Percentage of the dbspace file available for use. |
| IQ active operations | Number of active concurrent operations admitted by Sybase IQ resource governor. |
| IQ threads in use | Number of threads used by the Sybase IQ server. |
| IQ waiting operations | Number of IQ operations waiting for the resource governor. |
| Main cache dirty pages percent | Percentage of pages in the main cache where data has been modified and stored in the buffer cache and has not yet been written to disk. |
| Main cache hits | Number of main cache hits per second. |
| Main cache in use percent | Percentage of the main cache in use. |
| Main cache pinned | Number of pinned main cache pages. |
| Main cache pinned percent | Percentage of the main cache pinned. |
| Main cache reads | Number of main cache page lookups per second. |
| Main cache size | Current main cache size in megabytes. |
| Main store disk reads | Number of kilobytes per second that have been read from the main store. |
| Main store disk writes | Number of kilobytes per second that have been written to the main store. |
| Maximum memory allocated | Maximum memory allocated by the Sybase IQ server in megabytes. |
| Memory allocated | Memory allocated by the Sybase IQ server in megabytes. |
| Number of active connections | Total number of active connections, including user and internode communication connections. |
| Number of connections available | Number of concurrent connections available. |
| Number of IQ threads available | Number of threads available in the IQ server. |
| Requests per second | Number of times per second the server has been accessed to handle a new request or continue processing an existing request. |
| Server availability |
State of the Sybase IQ server. Valid values are:
|
| Temp cache dirty pages percent | Percentage of pages in the temporary cache where data has been modified and stored in the buffer cache and has not yet been written to disk. |
| Temp cache hits | Number of temporary cache hits per second. |
| Temp cache in use percent | Percentage of the temporary cache in use. |
| Temp cache pinned | Number of pinned temporary cache pages. |
| Temp cache pinned percent | Percentage of the temporary cache pinned. |
| Temp cache reads | Number of temporary cache page lookups per second. |
| Temp cache size | Current temporary cache size in megabytes. |
| Temp store disk reads | Number of kilobytes per second that have been read from the temporary store. |
| Temp store disk writes | Number of kilobytes per second that have been written to the temporary store. |
| Total communication buffers | Total number of network communication buffers. |
| Unscheduled requests | Number of requests that are currently queued up waiting for an available server thread. |
| User connections per minute | Number of user connections per minute. |
| User disconnections per minute | Number of user disconnections per minute. |