Contents Index Configuring the Sybase Central Performance Monitor Fragmentation

ASA SQL User's Guide
  Monitoring and Improving Performance
    Monitoring database performance

Monitoring database statistics from Windows Performance Monitor


As an alternative to using the Sybase Central Performance Monitor, you can use the Windows Performance Monitor.

The Windows monitor has two advantages:

For a complete list of performance statistics you can monitor, see Performance Monitor statistics.

Note: Windows Performance Monitor is available in Windows NT, Windows 2000, and Windows XP. If you run multiple versions of Adaptive Server Anywhere simultaneously, it is also possible to run multiple versions of the Performance Monitor simultaneously.

To use the Windows Performance Monitor in Windows NT

  1. With an Adaptive Server Anywhere engine or database running, start the Performance Monitor:

  2. Choose Edit > Add To Chart, or click the Plus sign button on the toolbar. The Add To Chart dialog appears.

  3. From the Object list, select one of the following:

    The Counter box displays a list of the statistics you can view.

  4. From the Counter list, click a statistic to view. To select multiple statistics, hold the Ctrl or Shift keys while clicking.

  5. If you selected Adaptive Server Anywhere Connection or Adaptive Server Anywhere Database, choose an instance from the Instance box.

  6. For a description of the selected counter, click Explain.

  7. To display the counter, click Add.

  8. When you have selected all the counters you wish to display, click Done.

For more information about the Windows Performance Monitor, see the online help for the program.


Contents Index Configuring the Sybase Central Performance Monitor Fragmentation