Processes

Monitor Adaptive Server processes.

• Identifying Resource-Intensive Processes
  Find the user processes that are consuming the most system resources on the selected Adaptive Server.
• Identifying Blocked Processes and Blocking Processes
  Find user processes that are blocked and the processes that are blocking them.
• Terminating Blocking Processes
  Terminate a blocking process from the Processes window.
• Identifying the Lead Blocker in a Chain
  Find a process that is blocking several other processes.
• Displaying the SQL Query Associated with a Process
  See the SQL statement and query plan for an Adaptive Server user process.
• Displaying Wait Events for a Process
  Get information about wait events that are affecting an Adaptive Server process.
• Process Statistics and Details
  Interpret Adaptive Server process information.

---

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