Availability and performance statistics in Sybase Control Center for
Adaptive Server can help you determine whether your systems are 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 have 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.