Jonathan Kehayias is a Principal Consultant with SQLskills, and was the youngest person to achieve the Microsoft Certified Master - SQL Server certification. He is heavily involved in the SQL community; including being a top answerer on the MSDN Database Engine forum, writing deep technical content on his blog and articles online. He is a performance tuning expert, both SQL Server and hardware, and has architected complex systems as a developer, business analyst, DBA, and consultant.
Sessions
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.