It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Jonathan Kehayias

Jonathan Kehayias is a SQL Server MVP and Principal Consultant with SQLskills.

Extended Events offer a refreshing new way of troubleshooting problems with SQL Server 2008. This session will focus on how to create custom sessions using the available events, targets and actions available in the Extended Events metadata. It will cover how to use the default system_health session to perform initial troubleshooting, as well as how to use the Extended Events Manager to simplify creating Extended Event Sessions and accessing the information captured in the session targets.

This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.