The Information section in the Performance Monitor provides information about Cache, Processes, SQL Statements, Locks, Sys Worker Threads, Sys Waits and the Error Log.
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. |
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. |
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. |
Returns a list of all locks that are being held, and those that have been requested, by any process, for every object.
Provides server-wide statistics related to worker threads.
Provides a server-wide view of where processes are waiting for an event.
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
