Retrieving Deadlock Graphs with SQL Server 2008 Extended Events

Return to previous page

  • 4/7/2015
  • 1591 Views

Comments

1591 Views

Retrieving Deadlock Graphs with SQL Server 2008 Extended Events

Last updated 6 years ago

Comments

Common

(Enter the content of this article below)

Advanced

 
SQL Server extended events (Extended Events) is a general event-handling system for server systems. The Extended Events infrastructure supports the correlation of data from SQL Server, and under certain conditions, the correlation of data from the operating system and database applications. In the latter case, Extended Events output must be directed to Event Tracing for Windows (ETW) in order to correlate the event data with operating system or application event data.

You can use Extended Events for a wide range of monitoring and troubleshooting scenarios. The following scenarios illustrate a few of the situations where Extended Events can provide valuable data for resolving issues in such areas as:

  • Troubleshooting the cause of working set trimming.
  • Troubleshooting excessive CPU usage.
  • Troubleshooting deadlocks.
  • Correlating request activity with Windows ETW logs.

SQL Server 2008 actually ships with a pre-defined session that is set to run by default and is called the system_health session. The following article has a few examples of accessing the system_health session sql 2008 extended events for deadlocks and can be useful in determining their cause.

Additional references:

Contents
No sections defined
Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out