ASA SQL User's Guide
Monitoring and Improving Performance
Performance analysis tools
The Performance Monitor is useful for tracking detailed information about database server actions, including disk and memory access.
With the Sybase Central Performance Monitor, you can graph a variety of statistics of any Adaptive Server Anywhere database server that you can connect to in Sybase Central. All statistics in Sybase Central are shown in the Statistics folder.
Features of the Performance Monitor include:
Real-time updates (at adjustable intervals)
A color-coded and resizable legend
Configurable appearance properties
When you're using the Sybase Central Performance Monitor, note that it uses actual queries against the server to gather its statistics, so the monitor itself affects some statistics (such as Cache Reads/sec). As a more precise alternative, you can graph server statistics using the Windows Performance Monitor.
The Windows monitor has two advantages:
It offers more performance statistics (mainly those concerned with network communications).
Unlike the Sybase Central monitor, the Windows monitor is non-intrusive. It uses a shared-memory scheme instead of performing queries against the server, so it does not affect the statistics themselves.
If you run multiple versions of Adaptive Server Anywhere simultaneously, it is also possible to run multiple versions of the Performance Monitor simultaneously