Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Monitoring database performance

Adding and removing statistics Next Page

Monitoring statistics using Windows Performance Monitor

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

The Windows Performance Monitor offers more performance statistics than the Sybase Central Performance Monitor, especially network communication statistics. It also uses a shared-memory scheme instead of performing queries against the database server, so it does not affect the statistics themselves.

The Windows Performance Monitor is available on Windows. If you run multiple versions of SQL Anywhere simultaneously, it is also possible to run multiple versions of the Performance Monitor simultaneously.

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

To use the Windows Performance Monitor
  1. With a SQL Anywhere server running, start the Performance Monitor:

  2. Choose the Plus sign tool (+) on the toolbar. The Add Counters dialog appears.

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

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

    If you selected SQL Anywhere Connection or SQL Anywhere Database, the Instances box displays a list of the connections or databases upon which you can view statistics.

  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 SQL Anywhere 10 Connection or SQL Anywhere 10 Database, choose a database connection or database to monitor from the Instances 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 want to display, click Close.