|
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.
With a SQL Anywhere server running, start the Performance Monitor:
Choose Administrative Tools from the Windows Control Panel.
Choose Performance to start the Windows Performance Monitor.
Choose the Plus sign tool (+) on the toolbar. The Add Counters dialog appears.
From the Performance Object list, select one of the following:
SQL Anywhere 10 Connection This monitors performance for a single connection. A connection must currently exist in order to see this selection.
SQL Anywhere 10 Database This monitors performance for a single database.
SQL Anywhere 10 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.
From 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 10 Connection or SQL Anywhere 10 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.