|
You may also need to investigate deadlocks. Deadlocks occur when two or more connections are waiting for each other to finish, and thus neither is able to finish. If deadlocks occurred during your tracing session, you can investigate them in Application Profiling mode. To do this, open the tracing session, and view the Deadlocks tab in the Application Profiling Details area (lower pane) in Sybase Central.
The Deadlock tab shows a graphical representation of each deadlock that was recorded during the tracing session. You can examine the connections that participated and the statements that each connection blocked while trying to execute. If you traced to the local database, you can also view the primary keys for the rows for which locks could not be acquired.
For more information about deadlocks and what causes them to occur, see Transaction blocking and deadlock.