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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Application profiling tutorials » Tutorial: Diagnosing deadlocks


Lesson 5: Viewing deadlock data

Use the following procedure to view additional deadlock data, such as how often they occur, and how long they last. Use the Connection Blocks tab to view a list of all deadlocks recorded during the database tracing session.

♦  To view deadlock data
  1. In the Application Profiling Details pane, click the Database Tracing Data tab.

  2. Click the Connection Blocks tab, just above the Database Tracing Data tab.

    The Connection Blocks tab appears, displaying block time, unblock time, and duration of each blocked connection.

See also