ASA SQL User's Guide
Monitoring and Improving Performance
Monitoring database performance
As an alternative to using the Sybase Central Performance Monitor, you can use 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.
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
With an Adaptive Server Anywhere engine or database running, start the Performance Monitor:
Choose Start
Choose Edit
From the Object list, select one of the following:
Adaptive Server Anywhere Connection To monitor performance for a single connection. Choose a connection to monitor from the displayed list.
Adaptive Server Anywhere Database To monitor performance for a single database. Choose a database to monitor from the displayed list.
Adaptive Server Anywhere Engine To monitor performance on a server-wide basis.
The Counter box displays a list of the statistics you can view.
From the Counter list, click a statistic to view. To select multiple statistics, hold the Ctrl or Shift keys while clicking.
If you selected Adaptive Server Anywhere Connection or Adaptive Server Anywhere Database, choose an instance from the Instance box.
For a description of the selected counter, click Explain.
To display the counter, click Add.
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.