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.
There are database server options you can specify when starting the database server that control the memory used by the Windows Performance Monitor, as well as 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 Microsoft 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
With a SQL Anywhere server running, start the Performance Monitor:
On the toolbar, click the Plus sign tool (+).
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.
In the Counter list, click a statistic to view. To select multiple statistics, hold the Ctrl or Shift keys while clicking.
If you selected SQL Anywhere 11 Connection or SQL Anywhere 11 Database, choose a database connection or database to monitor from the Instances box.
For a description of the selected counter, click Explain.
To display the counter, click Add.
When you have selected all the counters you want to display, click Close.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |