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.
Start the Performance Monitor:
From the Windows Control Panel, click Administrative Tools.
Click Performance.
On the toolbar, click the Plus sign tool (+).
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.
In the Counter list, click a statistic to view.
If you clicked SQL Anywhere 12 Connection or SQL Anywhere 12 Database, choose a database connection or database to monitor from the Instances box.
For information about the selected counter, click Explain.
To display the counter, click Add.
When you have selected all the counters you want to display, click Close.
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.
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.
In the Counter list, click a statistic to view.
If you clicked SQL Anywhere 12 Connection or SQL Anywhere 12 Database, choose a database connection or database to monitor from the Instances box.
For information about the selected counter, click Show Description.
To display the counter, click Add.
When you have selected all the counters you want to display, click OK.
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |