Collection of Adaptive Server data may be scheduled through either a default data collection or preconfigured
statistics collections.
When an Adaptive Server is first authenticated, Sybase Control Center sets up a default collection of data called collection_ase_availability. The data in the default collection is gathered in 60 second intervals. The KPIs used in the default collection include Server Percent CPU Utilization, Number of Blocked Processes, Number of Suspended Processes, and Server Availability State.
Note: The default collection contains the same key performance indicators (KPIs) as the Perspective Heatchart, and therefore these KPIs need not be scheduled in additional collections.
The user who first authenticates and monitors an Adaptive Server resource owns its default collection. You can begin to schedule a default collection in one of these ways:
- Authenticate an Adaptive Server after registering it. This is the default method of scheduling a default collection.
- Create a scheduled job that is initiated when the Sybase Control Center server starts.
Set up jobs in the scheduler to collect these preconfigured statistics collections:
-
collection_ase_all_client_kpis – Collects the data for historical charts in the Adaptive Server component, including those on the Overview, Devices, Engines, and Segments screens in the Adaptive Server monitor. Schedule this collection to see real time charting for these resources.
-
collection_ase_histmon – Collects historical statistics for an Adaptive Server. These statistics are not displayed in the Adaptive Server monitor. To view these statistics, launch the 'Statistics Chart' window from the context menu. Schedule this collection to activate alerts and view them in a statistics chart.
-
collection_ase_rat – Collects RepAgent Threads metrics for the charts on the Adaptive Server component’s Replication Agent screen. Include this collection only if you are planning to monitor replication from this primary database.
Schedule the collections for every 60 seconds. See Creating a Data Collection Job (linked below) for instructions on using the scheduler.