Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Advanced application profiling using diagnostic tracing » Analyzing diagnostic tracing information

Debugging application logic Next Page

Investigating deadlocks

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.