Sybase IQ Data Collections

Predefined data collections you can schedule for Sybase IQ. Collected statistics appear on Sybase Control Center monitoring screens and trigger user-configured alerts.

Sybase provides alternative versions of several data collections to avoid duplication. 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

The “w/o Availability” collections omit statistics that are collected by the Availability Statistics Collection or the Multiplex Availability Collection, which are scheduled by default. They are otherwise identical to their counterparts.

Minimizing duplication:

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

A statistic is considered a duplicate only when its key performance indicator is collected more than once in the same time interval. For example, if you schedule both the All Statistics Collection and the Availability Statistics Collection at 15-minute intervals, the data collected for the Availability Statistics Collection is duplicated—all of its KPIs are also in the All Statistics Collection. If you schedule the All Statistics Collection at 30-minute intervals and the Availability Statistics Collection at 5-minute intervals, however, the data is not duplicated.

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.
Availability Statistics Collection	Contains server availability statistics used in the heat chart. This is the default collection; it is automatically scheduled when you authenticate a Sybase IQ simplex server. Important: Sybase strongly recommends that you 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 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
All Stats w/o Availability	Contains all statistics except those collected by the Availability Statistics Collection. Schedule this collection to collect all statistics without duplication when you also use the Availability Statistics Collection, which is scheduled by default.	All KPIs listed in this table with the exception of those included in the Availability Statistics Collection, above.
Engine Statistics Collection	Contains performance statistics for the 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 that are also 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 Available Connections Active User Connections Active INC Incoming Connections Active INC Outgoing Connections User Connections Per Minute User Disconnections Per Minute
Connection Stats w/o Availability	Contains all statistics in the Connection Statistics Collection except those that are also 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
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 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 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
Cache Stats w/o Availability	Contains all statistics in the Cache Statistics Collection except those that are also 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 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 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
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.	Multiplex Status The following KPIs for each node: Server Status SCC Agent Status Multiplex Role Multiplex Status Multiplex Failover Node INC Status Total CPU Usage System CPU Usage User CPU Usage IQ Memory Allocated IQ Maximum Memory Allocated IQ Threads in Use IQ Threads Available Active Connections Available Connections Active User Connections Active INC Incoming Connections Active INC Outgoing Connections User Connections Per Minute User Disconnections Per Minute Active Transactions Active User Transactions Active INC Transactions Active Load Table Statements IQ Waiting Operations IQ Active Operations Requests Per Second Unscheduled Requests Bytes Received Per Second Bytes Received Uncompressed Per Second Bytes Sent Per Second Bytes Sent Uncompressed Per Second Available Communication Buffers Total Communication Buffers The following KPIs for each dbspace: Percentage of Available DBSpace DBSpace Size in Use The following KPIs for each dbspace file: Percentage of Available DBSpace File DBSpace File Size in Use The following KPIs for stores: 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 The following KPIs 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 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 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
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: Sybase strongly recommends that you 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 The following KPIs of each node: Server Status 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 Multiplex Role Multiplex Status Multiplex Failover Node INC Status
All MPX Stats w/o Availability	Contains all statistics except those collected by the Multiplex Availability Collection. Schedule this collection to collect all statistics without duplication when you also use the Multiplex Availability Collection, which is scheduled by default.	All KPIs listed in this table with the exception of those included in the Multiplex Availability Collection, above.