The Wait Events Page displays a summary of Wait Event metrics and consists of a pie chart and two grids.
The Wait Events by Class pie chart displays wait events broken down by wait class.
The Wait Events by SPID grid displays all users with the highest number of waits. The following columns are available:
Column |
Definition |
SPID |
Process ID |
Application Name |
Name of application |
Wait Count |
The number of waits that have occurred for this user. |
Total Wait Time (sec) |
Total wait time in seconds |
The Wait Events grid displays when you select a line from the Wait Events by SPID grid.
Note: Wait Event metrics are only available for 12.5.03 or later servers.
The following columns are available:
Column |
Definition |
Event |
Description of the wait event. |
Wait Count |
The number of waits that have occurred for this user for this application. |
Wait_time (ms) |
Wait time in seconds for this user for this application. |
Note: Metrics will not be shown for users who have logged off Adaptive Server before Spotlight connected. System processes will be shown.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center