Displaying Wait Events for a Process

Get information about wait events that are affecting an Adaptive Server process.

  1. In the Perspective Resources view, right-click the server to monitor and select Monitor.
  2. In the left pane, select Processes.
  3. Click All Processes. Each row of the table below the bar graph displays information about a process.
  4. (Optional for Adaptive Server cluster configurations) Click Select User Processes by. Choose All Instances to depict information for the entire cluster, or select a specific instance to see information for only the selected instance of the cluster.
  5. To select a process, click a row in the table.
  6. Click Wait Events.
For more information on wait events, see the wait events chapter in the Adaptive Server Performance and Tuning Series: Monitoring Tables guide.
Related tasks
Displaying the SQL Query Associated with a Process
Identifying the Lead Blocker in a Chain
Identifying Resource-Intensive Processes
Identifying Blocked Processes and Blocking Processes
Terminating Blocking Processes
Related reference
Process Statistics and Details


Created February 25, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com