Contents Index Graphical plan Timing utilities

ASA SQL User's Guide
  Monitoring and Improving Performance
    Performance analysis tools

Performance Monitor


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:

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:

If you run multiple versions of Adaptive Server Anywhere simultaneously, it is also possible to run multiple versions of the Performance Monitor simultaneously


Contents Index Graphical plan Timing utilities