Key Performance Indicators for Sybase IQ

Key performance indicators (KPIs) provide the statistics that appear on Sybase IQ screens and charts in Sybase Control Center.

Each Sybase IQ data collection includes a subset of the KPIs listed here.

Sybase IQ Availability Statistics
KPI	Description
Server Status (Resource State)	Status of the Sybase IQ server. Valid states are: UNKNOWN (0) STOPPED (1) PENDING (2) RUNNING (3) WARNING (4) ERROR (5)
Total CPU Usage	Sybase IQ server total CPU usage percentage, including both system and user usage.
CPU System Usage	Sybase IQ server system CPU usage percentile.
CPU User Usage	Sybase IQ server user CPU usage percentile.
IQ Memory Allocated	Memory allocated by the Sybase IQ server, in megabytes.
Catalog Cache in Use	Percentage of catalog cache in use.
Temporary Cache in Use	Percentage of temporary cache in use.
Main Cache in Use	Percentage of main cache in use.
Available Connections	Number of concurrent connections available.

Sybase Control Center Agent Availability Statistics
KPI	Description
SCC Agent Status (Resource State)	Status of the registered and authenticated SCC agent that enables SCC to manage the Sybase IQ server. Valid states are: UNKNOWN (0) STOPPED (1) PENDING (2) RUNNING(3) WARNING (4) ERROR (5)

Multiplex Availability Statistics
KPI	Description
Multiplex Status (Resource State)	Status of the multiplex. Valid states are: UNKNOWN (0) STOPPED (1) (A multiplex is considered stopped if there is no running node.) PENDING (2) RUNNING (3) (A multiplex is considered to be running if at least one node is running.) WARNING (4) ERROR (5)

Multiplex Node Properties
KPI	Description
Multiplex Role (Resource Secondary State)	Indicates the multiplex role of the node. Valid states are: COORDINATOR (0) WRITER (1) READER (2) SINGLE_SERVER (3)
Multiplex Status	Indicates the multiplex status of the node. Valid values are: INCLUDED (0) EXCLUDED (1)
Multiplex Failover Node	Indicates whether the node is a designated failover node. Valid values are: FALSE (0) TRUE (1)

Multiplex Link Availability Statistics
KPI	Description
INC Status (Resource State)	Status of inter-node communication between a secondary node and the coordinator. Valid states are: UNKNOWN (0) STOPPED (1) PENDING (2) ACTIVE (3) WARNING (4) ERROR (5)

Overview Statistics
KPI	Description
Server Status	Server state or status. Valid values are: UNKNOWN (0) STOPPED (1) PENDING (2) RUNNING (3) WARNING (4) ERROR (5)
Total CPU Usage	Sybase IQ server total CPU usage percentage, including both system and user usage.
IQ Memory Allocated	Memory allocated by the Sybase IQ server, in megabytes.
Number of Active Connections	Total number of active connections including user and inter-node-communication connections.

Engine Statistics
KPI	Description
Total CPU Usage	Sybase IQ server total CPU usage percentage, including both system and user usage.
CPU System Usage	Sybase IQ server system CPU usage percentile.
CPU User Usage	Sybase IQ server user CPU usage percentile.
IQ Memory Allocated	Memory allocated by the Sybase IQ server, in megabytes.
IQ Maximum Memory Allocated	Maximum memory allocated by the Sybase IQ server, in megabytes.
IQ Threads in Use	Number of threads used by the Sybase IQ server.
IQ Threads Available	Number of threads available in the Sybase IQ server.

Connection Statistics
KPI	Description
Active Connections	Total number of active connections including user and inter-node-communication connections.
Available Connections	Number of concurrent connections available.
Active User Connections	Number of active user connections.
Active INC Incoming Connections	Number of inter-node-communication incoming connections.
Active INC Outgoing Connections	Number of inter-node-communication outgoing connections.
User Connections Per Minute	Number of user connections per minute.
User Disconnections Per Minute	Number of user disconnections per minute.

Transaction Statistics
KPI	Description
Active Transactions	Total number of active transactions, including user and INC transactions.
Active User Transactions	Number of active user transactions.
Active INC Transactions	Number of active inter-node communication transactions.
Active Load Table Statements	Number of active LOAD TABLE statements.

DBSpace and DBSpace File Statistics
KPI	Description
Percentage of Available DBSpace	Percentage of the dbspace that is available.
DBSpace Size in Use	Dbspace size in use (MB).
Percentage of Available DBSpace File	Percentage of space available in the dbspace file.
DBSpace File Size in Use	Dbspace file size in use (MB).

Store Input and Output Statistics
KPI	Description
Catalog Store Disk Reads Per Second	Number of kilobytes per second that have been read from the catalog store.
Catalog Store Disk Writes Per Second	Number of kilobytes per second that have been written to the catalog store.
Temporary Store Disk Reads Per Second	Number of kilobytes per second that have been read from the temporary store.
Temporary Store Disk Writes Per Second	Number of kilobytes per second that have been written to the temporary store.
Main Store Disk Reads Per Second	Number of kilobytes per second that have been read from the main store.
Main Store Disk Writes Per Second	Number of kilobytes per second that have been written to the main store.

Cache Statistics
KPI	Description
Catalog Cache Hits Per Second	Number of catalog cache hits per second.
Catalog Cache Reads Per Second	Number of catalog cache page lookups per second.
Catalog Cache Size	Current catalog cache size, in megabytes.
Catalog Cache in Use	Percentage of catalog cache in use.
Catalog Cache Pinned	Number of pinned catalog cache pages.
Catalog Cache Pinned Percent	Percentage of catalog cache pinned.
Catalog Cache Dirty Pages Percent	Percentage of catalog cache dirty pages.
Temporary Cache Hits Per Second	Number of temporary cache hits per second.
Temporary Cache Reads Per Second	Number of temporary cache page lookups per second.
Temporary Cache Size	Current temporary cache size, in megabytes.
Temporary Cache in Use	Percentage of temporary cache in use.
Temporary Cache Pinned	Number of pinned temporary cache pages.
Temporary Cache Pinned Percent	Percentage of temporary cache pinned.
Temporary Cache Dirty Pages Percent	Percentage of temporary cache dirty pages.
Main Cache Hits Per Second	Number of main cache hits per second.
Main Cache Reads Per Second	Number of main cache page lookups per second.
Main Cache Size	Current main cache size, in megabytes.
Main Cache in Use	Percentage of main cache in use.
Main Cache Pinned	Number of pinned main cache pages.
Main Cache Pinned Percent	Percentage of main cache pinned.
Main Cache Dirty Pages Percent	Percentage of main cache dirty pages.

Operations and Requests Statistics
KPI	Description
IQ Waiting Operations	Number of Sybase IQ operations waiting for the resource governor.
IQ Active Operations	Number of active concurrent operations admitted by the Sybase IQ resource governor.
Requests Per Second	Number of times per second the server has been entered to allow it to handle a new request or continue processing an existing request.
Unscheduled Requests	Number of requests that are currently queued up waiting for an available server thread.

Network Statistics
KPI	Description
Bytes Received Per Second	Number of bytes per second received during client/server communications.
Bytes Received Uncompressed Per Second	Number of bytes per second that would have been received during client/server communications if compression was disabled.
Bytes Sent Per Second	Number of bytes per second sent during client/server communications.
Bytes Sent Uncompressed Per Second	Number of bytes per second that would have been sent during client/server communications if compression was disabled.
Available Communication Buffers	Number of available network communication buffers.
Total Communication Buffers	Total number of network communication buffers.