Right Pane for Information
The Information section in the Performance Monitor provides information about Cache, Processes, SQL Statements, Locks, Sys Worker Threads, Sys Waits and the Error Log.
Cache Information
The Cache Information section has the following information:
| Statistic | Description |
|
Provides statistics for all objects and indexes with pages currently in a data cache. | |
|
Provides statistics for all procedures currently stored in the procedure cache. |
Process Information
The Process Information section has the following information:
| Statistic | Description |
|
Processes |
Provides detailed statistics about processes that are currently executing or waiting. |
|
Process Objects |
Provides statistical information regarding database objects that have been accessed by processes. |
|
Process Procedures |
Provides a list of all procedures that are being executed by processes. |
|
Provides information enabling processes to be tracked to an application, user, client machine, and so on. | |
|
Provides information about process use of worker threads. | |
|
Process Waits |
Provides a server-wide view of where processes are waiting for an event. |
SQL Statement Information
This SQL Statement Information section provides information about currently executing SQL statements and recently executed SQL statement.
| Statistic | Description |
|
Executing SQL |
Provides information for currently executing statements. |
|
Executed SQL |
Provides statistics pertaining to the most recently executed statements. The maximum number of statement statistics returned can be set with statement pipe max messages Adaptive Server configuration parameter. |
Locks Information
Returns a list of all locks that are being held, and those that have been requested, by any process, for every object.
Sys Worker Threads
Provides server-wide statistics related to worker threads.
Sys Waits
Provides a server-wide view of where processes are waiting for an event.
Error Log
Returns the most recent error messages from the Adaptive Server error log. The maximum number of messages returned can be set with the errorlog pipe max messages Adaptive Server configuration parameter.
Status Bar
The status bar at the bottom of the Performance Monitor window has the following information.
| Item | Description |
|
Server |
Adaptive Server name |
|
User |
Default user for the login account |
|
Login |
Login account name |
|
Interval |
Interval setting for retrieving the statistics from the monitoring tables from the Preferences settings. |
|
CNF |
The Chart Data Normalization Factor from the Preferences settings. |
|
Monitor Status Icon |
When the Monitor Status icon at the far right of the status bar is green |
, the Performance Monitor is idle. When the Status icon at the far right of the status bar is red 
, it is retrieving the statistics from the monitoring tables.
Open the Performance Monitor
To open the Performance Monitor window
Click 
Connect and Disconnect from Database
When the Performance Monitor window is opened from within SQL Optimizer, the current SQL Optimizer logon is used.
If you open Performance Monitor window outside of SQL Optimizer, you are prompted to logon to a server. You can disconnect from or reconnect to a server without closing the Performance Monitor window.
To connect to a different server
Click 
To disconnect from a server
Click 
View connection information
To find out if the server has the necessary parameter settings and your current logon has the necessary privileges needed to run the Performance Monitor, select Database | View Connection Information.
The Connection Information window confirms that your logon has the necessary the privileges to run the Performance Monitor or tells which privileges your logon is lacking under the Privilege Information tab.
Certain Adaptive Server configuration parameters are needed to run the Performance Monitor. The Configuration Information tab in the Connection Information window shows the current settings for these parameters and the parameter values that are necessary. If the current parameter value does not meet the required value, the line for configuration parameter is highlighted in red.