SAP Sybase IQ Data Collections

Predefined data collections that generate statistics for the historical data displayed in the Statistics Chart. Collected statistics appear on the SAP Control Center statistics charts and trigger user-configured alerts.

The Availability Statistics Collection, the Multiplex Availability Collection, and the Logical Server Availability Collection are collections which are scheduled by default. If you delete one of these scheduled jobs, it is automatically re-scheduled the next time you authenticate an SAP Sybase IQ server.

Many of the data collections collect the same data. To avoid duplication, SAP Sybase IQ provides alternative versions of several data collections. The alternatives (which are all described in the tables below) are:

All Statistics Collection and All Stats w/o Availability
Engine Statistics Collection and Engine Stats w/o Availability
Connection Statistics Collection and Connection Stats w/o Availability
Cache Statistics Collection and Cache Stats w/o Availability
All Multiplex Statistics Collection and All MPX Stats w/o Availability
All Logical Server Statistics Collection and All Logical Server Stats w/o Availability

The “w/o Availability” collections omit those statistics already collected by the default collections. They are otherwise identical to their counterparts.

For example, Total CPU Usage and User CPU Usage statistics are both gathered by the Availability Statistics and Engine Statistics collections. If you do not need to collect any additional Engine statistics, you do not need to schedule the Engine Statistics collection; the Availability Statistics collection is sufficient. However, if you also needed to gather IQ Maximum Memory Allocated, IQ Threads in Use, or IQ Threads Available statistics, you would need to schedule the Engine Statistics collection, but to prevent duplication of the common statistics, you would schedule the w/o Availability version of the Engine Statistics collection.

A statistic is considered a duplicate only when its key performance indicator is collected more than once in the same time interval.

Minimizing duplication:

Reduces the occurrence of duplicate alerts
Improves the performance of both SAP Control Center and managed servers

Data Collections for Server-Type (Simplex) Resources
Collection	Description	KPIs
All Statistics Collection	Contains all statistics, including server availability and performance statistics.	All KPIs listed in this table.
All Stats w/o Availability	Contains all statistics except those collected by the Availability Statistics Collection. To avoid duplication with the Availability Statistics Collection, schedule this collection rather than the All Statistics Collection.	All KPIs listed in this table with the exception of those included in the Availability Statistics Collection, below.
Availability Statistics Collection	Contains server availability statistics used in the heat chart. This is the default collection; it is automatically scheduled when you authenticate an SAP Sybase IQ simplex server. Important: Leave this collection running for each monitored simplex server. Suspend it only if you schedule another collection that includes all of this collection's KPIs, such as All Statistics Collection.	Server Status (Resource State) SCC Agent Status Total CPU Usage System CPU Usage User CPU Usage IQ Memory Allocated Catalog Cache in Use Main Cache in Use Temporary Cache in Use Available Connections
Engine Statistics Collection	Contains performance statistics for the SAP Sybase IQ engine.	Total CPU Usage System CPU Usage User CPU Usage IQ Memory Allocated IQ Maximum Memory Allocated IQ Threads in Use IQ Threads Available
Engine Stats w/o Availability	Contains all statistics in the Engine Statistics Collection except those collected by the Availability Statistics Collection. To avoid duplication with the Availability Statistics Collection, schedule this collection rather than the Engine Statistics Collection.	IQ Maximum Memory Allocated IQ Threads in Use IQ Threads Available
Connection Statistics Collection	Contains connection performance statistics.	Active Connections Active INC Incoming Connections Active INC Outgoing Connections Active User Connections Available Connections Resumed INC Connections Rolled back INC Connections Suspended INC Connections User Connections Per Minute User Disconnections Per Minute
Connection Stats w/o Availability	Contains all statistics in the Connection Statistics Collection except those collected by the Availability Statistics Collection. To avoid duplication with the Availability Statistics Collection, schedule this collection rather than the Connection Statistics Collection.	Active Connections Active User Connections Active INC Incoming Connections Active INC Outgoing Connections User Connections Per Minute User Disconnections Per Minute
RLV Memory Statistics Collection	Contains RLV memory statistics.	Percentage of Available RLV Memory RLV Memory Size in Use
Transaction Statistics Collection	Contains transaction performance statistics.	Active Transactions Active User Transactions Active INC Transactions Active Load Table Statements
DBSpace Statistics Collection	Contains statistics for each dbspace.	Percentage of Available DBSpace DBSpace Size in Use
DBSpace File Statistics Collection	Contains statistics for each dbspace file.	Percentage of Available DBSpace File DBSpace File Size in Use
Store I/O Statistics Collection	Contains performance statistics for store reads and writes.	Catalog Store Disk Reads Per Second Catalog Store Disk Writes Per Second Temporary Store Disk Reads Per Second Temporary Store Disk Writes Per Second Main Store Disk Reads Per Second Main Store Disk Writes Per Second
Cache Statistics Collection	Contains performance statistics for caches.	Catalog Cache Hits Per Second Catalog Cache Reads Per Second Catalog Cache Size Catalog Cache in Use Catalog Cache Pinned Catalog Cache Pinned Percent Catalog Cache Dirty Pages Percent Main Cache Hits Per Second Main Cache Reads Per Second Main Cache Size Main Cache in Use Main Cache Pinned Main Cache Pinned Percent Main Cache Dirty Pages Percent Temporary Cache Hits Per Second Temporary Cache Reads Per Second Temporary Cache Size Temporary Cache in Use Temporary Cache Pinned Temporary Cache Pinned Percent Temporary Cache Dirty Pages Percent
Cache Stats w/o Availability	Contains all statistics in the Cache Statistics Collection except those collected by the Availability Statistics Collection. To avoid duplication with the Availability Statistics Collection, schedule this collection rather than the Cache Statistics Collection.	Catalog Cache Hits Per Second Catalog Cache Reads Per Second Catalog Cache Size Catalog Cache Pinned Catalog Cache Pinned Percent Catalog Cache Dirty Pages Percent Main Cache Hits Per Second Main Cache Reads Per Second Main Cache Size Main Cache Pinned Main Cache Pinned Percent Main Cache Dirty Pages Percent Temporary Cache Hits Per Second Temporary Cache Reads Per Second Temporary Cache Size Temporary Cache Pinned Temporary Cache Pinned Percent Temporary Cache Dirty Pages Percent
Op/Req Statistics Collection	Contains performance statistics related to operations and requests.	IQ Waiting Operations IQ Active Operations Requests Per Second Unscheduled Requests
Network Statistics Collection	Contains network-related performance statistics.	Bytes Received Per Second Bytes Received Uncompressed Per Second Bytes Sent Per Second Bytes Sent Uncompressed Per Second Available Communication Buffers Total Communication Buffers

Data Collections for Multiplex-Type Resources
Collection	Description	KPIs
All Multiplex Statistics Collection	Contains all multiplex-related statistics and all statistics for each node. When scheduled, all node statistics are collected.	All KPIs listed in this table and, for each node, the statistics listed in the Data Collections for Server-Type (Simplex) Resources, above.
Multiplex Availability Collection	Contains multiplex status, availability statistics, and multiplex role/status/failover/INC status of each node. When scheduled, all node availability statistics are collected. This is the default collection; it is automatically created when you authenticate a multiplex-type resource. Important: Leave this collection running for each monitored multiplex server. Suspend it only if you schedule another collection that includes all of this collection’s KPIs, such as All Multiplex Statistics Collection.	Multiplex status Average Available Connections (Count) Average Catalog Cache in Use (Percent) Average CPU Usage (Percent) Average Main Cache in Use (Percent) Average Temporary Cache in Use (Percent) Maximum Available Connections (Count) Maximum Catalog Cache in Use (Percent) Maximum CPU Usage (Percent) Maximum Main Cache in Use (Percent) Maximum Temporary Cache in Use (Percent) Minimum Available Connections (Count) Minimum Catalog Cache in Use (Percent) Resource State (State) Total Available Connections (Count)
All MPX Stats w/o Availability	Contains all statistics except those collected by the Multiplex Availability Collection. To avoid duplication with the Multiplex Availability Statistics Collection, schedule this collection rather than the Cache Statistics Collection.	All KPIs listed in this table with the exception of those included in the Multiplex Availability Collection, above.

Data Collections for Logical Server Resources
Collection	Description	KPIs
Logical Server Statistics Collection	Contains all logical server-related statistics and all statistics for each node. When scheduled, all logical server statistics are collected.	The following KPIs for the logical server: Logical Server Status The following KPIs for Connections: Average CPU Usage Minimum CPU Usage Maximum CPU Usage Average Available Connections Minimum Available Connections Maximum Available Connections Total Available Connections Average User Connections Minimum User Connections Maximum User Connections Total User Connections The following KPIs for Transactions: Average User Transactions Minimum User Transactions Maximum User Transactions Total User Transactions Average Active Load Table Statements Minimum Active Load Table Statements Maximum Active Load Table Statements Total Active Load Table Statements The following KPIs for Caches: Average Catalog Cache in Use Minimum Catalog Cache in Use Maximum Catalog Cache in Use Average Temporary Cache in Use Minimum Temporary Cache in Use Maximum Temporary Cache in Use Average Main Cache in Use Minimum Main Cache in Use Maximum Main Cache in Use The following KPIs for Operations and Requests: Average Waiting Operations Minimum Waiting Operations Maximum Waiting Operations Total Waiting Operations Average Active Operations Minimum Active Operations Maximum Active Operations Total Active Operations
Logical Server Availability Statistics Collection	Contains logical server status and availability statistics status of each node. When scheduled, all node availability statistics are collected. This is the default collection; it is automatically created when you authenticate a logical server-type resource. Important: Leave this collection running for each monitored logical server. Suspend it only if you schedule another collection that includes all of this collection’s KPIs, such as All Logical Server Statistics Collection.	The following KPIs for the logical server: Logical Server Status Average CPU Usage Minimum CPU Usage Maximum CPU Usage Average Available Connections Minimum Available Connections Maximum Available Connections Total Available Connections Average Catalog Cache in Use Minimum Catalog Cache in Use Maximum Catalog Cache in Use Average Temporary Cache in Use Minimum Temporary Cache in Use Maximum Temporary Cache in Use Average Main Cache in Use Minimum Main Cache in Use Maximum Main Cache in Use
All Logical Server Stats w/o Availability	Contains all statistics except those collected by the Logical Server Availability Collection. To avoid duplication with the Logical Server Availability Collection, schedule this collection rather than the Cache Statistics Collection.	All KPIs listed in this table with the exception of those included in the Logical Server Availability Collection, above.