Server |
- State – current status of the server. Valid states include:
- Host – host name where the server is running.
- Port – port number where the server is running.
- Server name – name of the server.
- Database – name of the SAP Sybase IQ
database.
- Server type – type of server the database is on. Server types include
Single Server, Coordinator, Reader, and Writer.
- Server version – version of the SAP Sybase IQ
server.
- Platform – operating system running on the server host.
|
Activities |
- CPU total usage (%) – total CPU usage percentage, including both system and
user usage.
- Active connections – total number of active connections, including user and
internode communication connections.
- Connections available – number of connections available for users and internode
communication connections.
- Active requests – number of active requests on the server.
- IQ threads in use – number of threads being used by the
SAP Sybase IQ server.
- Active transactions – number of active transactions.
- Number of committed transactions – number of committed transactions.
- Oldest transaction (minutes) – elapsed age, in minutes, of the oldest transaction.
|
Caches |
- Catalog cache reads (per second) – number of catalog cache page lookups per second.
- Main cache size (MB) – size of the main buffer cache, in megabytes.
- Temp cache size (MB) – size of the temporary cache, in megabytes.
- Remaining heap size (MB) – size of the remaining heap allocation, in
megabytes.
|
Version Usage |
- Number of committed versions – the number of table versions in the server.
- Total version space used (MB) – total space consumed by all the table versions.
- Oldest version ID – the oldest version identifier on the server.
- Number of active versions – total number of active write table versions on the
server.
- Total active version space created (MB) – amount of data created by active write
transactions.
- Total active version space to be destroyed (MB) – amount of data destroyed by active write transactions.
If these transactions commit, the destroyed data becomes
an old version and is eventually dropped. If the
transactions roll back, the created data is
released.
|
Details |
- Server full version – version of the IQ server software, including the date
and time.
- Platform version – version of the operating system installed on the server
host.
|
Alerts |
Any alerts for the selected server. While the monitor is open,
alerts are displayed as they are created. |
CPU History |
Percentage of total CPU usage over a period of time. |
IQ Memory |
Allocation of the IQ memory between the main buffer cache,
temporary cache, and remaining heap. |
Disk Usage |
Available and used space for the main and temporary
stores. |