Set up a Statistics Collection in Sybase Control Center to monitor key performance indicators (KPI) on the server. KPI values are grouped into collections and appear in SCC monitors.
Key performance areas include SAP Sybase IQ servers, multiplex servers, and logical servers
Various server status and usage statistics.
|
Key Performance Area |
Usage Statistics |
|---|---|
|
SAP Sybase IQ Availability Statistics |
Resource state, CPU usage, memory allocation, cache use, and active connections. |
|
Overview Statistics |
Server status, CPU usage, memory allocation, and current active connections. |
|
Connection Statistics |
Active, available, resumed, rolled back, and suspended user and internode connections. Also displays average number of connections and disconnections per minute. |
|
DBSpace and DBSpace File Statistics |
Dbspace and dbspace file size and available percentage. |
|
Store Input and Output Statistics |
Store Input and Output Statistics identify store reads and writes per second. |
|
Cache Statistics |
Main, catalog, and temporary cache statistics. |
|
Operations and Request Statistics |
Average, minimum, maximum, and total waiting, active, and total operations. |
|
Network Statistics |
Network statistics display network activity. |
|
Transaction Statistics |
Transaction details currently on the server. |
Multiplex and node-related statistics for multiplex servers.
|
Key Performance Area |
|
|---|---|
|
Multiplex Availability |
Availability statistics for each multiplex node. |
|
Multiplex Status |
Status of the multiplex. |
|
Multiplex Node Properties |
Role, status, and failover state of each multiplex node. |
|
Multiplex Link Availability |
Internode communication status between a secondary node and the coordinator. |
Logical server and node-related statistics for logical servers.
|
Key Performance Area |
Usage Statistics |
|---|---|
|
Logical Server Availability |
Logical server status. |
|
Logical Server Engine Statistics |
CPU usage, connection, and connection statistics. |
|
Logical Server Connection |
Average, minimum, maximum, and total number of available connections. |
|
Logical Server Transaction |
Average, minimum, maximum, and total transactions. Also displays average and minimum number of load transactions. |
|
Logical Server Cache Statistics |
Average, minimum, and maximum cache use statistics for the catalog, temporary, and main cache. |
|
Logical Server Operations and Requests Statistics |
Average, minimum, maximum, and total waiting and active operations. |
For additional information, see the Sybase Control Center for SAP Sybase IQ online help in SCC or at http://sybooks.sybase.com/sybooks/sybooks.xhtml?prodID=10680.