Find a process
that is blocking several other processes.
When Process A blocks Process B, which blocks Process C—and so on—the blocking processes form a chain.
-
In the Perspective Resources view, right-click the server to monitor and select Monitor.
-
In the left pane, select Processes.
-
Click on Blocked Processes.
You see a table with information about blocked and blocking processes, including the lock requests on the basis of which processes are blocked.
-
(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.
-
The table on the Blocked Processes tab has an entry for each lead blocker; click the arrow to expand the entry and show all the blocked processes in the chain.
Note: Identifying the lock held by a blocking process is not always straightforward. For example, the blocking process does not necessarily hold a page lock; it might hold a table lock. For this reason, Sybase Control Center shows the lock request process that is blocking another process, not the blocking lock.
-
Select a process to populate the tabs at the bottom of the screen with information about that process.
-
Click the tabs to see:
Option |
Description |
Details
|
Details about the selected process, including the initiating program, transaction information, and network statistics |
SQL
|
The SQL statement and query plan for the selected process |
Wait Events
|
Information about wait events for the selected process, including number of waits, wait times, and wait descriptions |
-
(Optional) Click the All Processes tab at the top of the window.
In the table below the bar graph, rows highlighted in yellow are blocking processes. Rows highlighted in red are blocked processes.
Next
For information on handling blocked processes, see the
Adaptive Server Performance and Tuning Series: Locking and Concurrency Control. You can find Adaptive Server documentation on the Sybase Product Manuals Web site at
http://sybooks.sybase.com.