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

• Transaction blocking and deadlock
• Choosing a diagnostic tracing level
• Deadlock
• Advanced application profiling using diagnostic tracing