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 explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required.
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.