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.

 Use the Windows Performance Monitor (Windows XP)
  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 12 Connection   This monitors performance for a single connection. A connection must currently exist to see this selection.

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

    • SQL Anywhere 12 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 12 Connection or SQL Anywhere 12 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 12 Connection or SQL Anywhere 12 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.

 Use the Windows Performance Monitor (Windows 7)
  1. With a SQL Anywhere database server running, start the Performance Monitor:

    • From the Windows Control Panel, click All Control Panel Items.

    • Click Performance Information And Tools.

    • Click Advanced Tools.

  2. SQL Anywhere statistics appear in the list of counters for the computer.

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

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

    • SQL Anywhere 12 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 12 Connection or SQL Anywhere 12 Database, the Instances box displays a list of the connections or databases upon which you can view statistics.

  3. In the Counter list, click a statistic to view.

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

  5. For information about the selected counter, click Show Description.

  6. To display the counter, click Add.

  7. When you have selected all the counters you want to display, click OK.

Results

The specified statistics are displayed in the Windows Performance Monitor.

Next

None.