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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Performance monitoring and diagnostic tools » Database performance monitoring » Windows Performance Monitor

 

Using the Windows Performance Monitor

Use the Windows Performance Monitor when you want to view counters related to your SQL Anywhere database, server, or connection.

Prerequisites

A SQL Anywhere database server must be running.

Context and remarks

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

 Task
  1. Start the Performance Monitor:

    1. From the Windows Control Panel, click Administrative Tools.

    2. Click Performance.

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

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

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

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

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

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

    If you clicked SQL Anywhere 16 Connection or SQL Anywhere 16 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.

  5. If you clicked SQL Anywhere 16 Connection or SQL Anywhere 16 Database, choose a database connection or database to monitor from the Instances box.

  6. For information about 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.

Results

The specified statistics are displayed in the Windows Performance Monitor.