Availability and performance statistics
in Sybase Control Center for Adaptive Server can help you identify if your system is running as efficiently as possible.
Availability statistics are concerned with present conditions; they help you determine whether a system component you are monitoring (a server or a storage device, for example) is running and functioning properly. Performance statistics are concerned with behavior of the same components over time. You can use them to spot trends, identify problems or potential problems, and make plans.
Sybase Control Center includes predefined key performance indicators (KPIs) for Adaptive Server that are grouped into collections. KPIs such as Server Status, which serves as an availability statistic when it is fresh, also has long-term value as historical performance statistics.
Availability statistics appear on the heat chart and on the screens of the Adaptive Server monitor for each Adaptive Server. The Heat Chart includes these KPIs:
- Server Status (up or down)
- Server CPU Utilization
- Number of Blocked Processes
- Number of Suspended Processes
These KPIs are part of the default collection: collection_ase_availability.
Performance statistics appear on the Statistics Chart and on the screens of the Adaptive Server monitor for each Adaptive Server. In the Statistics Chart, you expand folders in the Statistics tab to drill down to specific KPIs. See the KPI values as tables or graphs, and compare them by displaying several KPIs together. These are the folders that contain KPIs you can use to display data:
- Server Overview
- Devices
- Engines
- Segments
- DataCaches
Adaptive Server cluster configurations have these additional folders on the Statistics Chart:
- Cluster Instances
- Cluster Workload
- Logical Clusters
- tempDBs Activity
To make specific KPIs available to the Statistics Chart and to the Adaptive Server monitor screens that use them, in addition to the availability statistics scheduled by default, set up collection jobs in the scheduler for:
- collection_ase_histmon – The KPIs in this collection are only available in the Statistics Chart, and for setting alerts.
- collection_ase_all_client_kpis – This collection is necessary to gather statistics for historical charts in the Adaptive Server Monitor. The statistics are also available in the Statistic Chart, and for setting alerts.
Several configuration options affect the collection and appearance of Adaptive Server data in Sybase Control Center:
- Collection repeat interval – the frequency of data collection. Set the repeat interval on the collection job in the scheduler. This option is set when the collection is scheduled, but may be modified later.
- Screen refresh interval – the period between screen refreshes. Refreshing the screen redraws it with the latest available data. This option can be configured from the Settings window.
- Chart trend period – the period over which data appears in historical charts. This option can be configured from the Settings window.