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

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

 

Monitor 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.

When starting the database server that controls the memory used by the Windows Performance Monitor, you can specify the database server options, and the maximum number of connections or database that the Performance Monitor can monitor. See:

The following instructions explain how to start Windows Performance Monitor on Windows XP. For other versions of Windows, consult your Windows operating system documentation for information about how to start Windows Performance Monitor.

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

    • From the Windows Control Panel, choose Administrative Tools.

    • Choose Performance.

  2. On the toolbar, click the Plus sign tool (+).

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

    • SQL Anywhere 11 Connection   This monitors performance for a single connection. A connection must currently exist to see this selection.

    • SQL Anywhere 11 Database   This monitors performance for a single database.

    • SQL Anywhere 11 Server   This monitors performance on a server-wide basis.

    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. In 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 11 Connection or SQL Anywhere 11 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.