Diving into Extended Events
Presenter: Jonathan Kehayias
At PASS Summit 2010, after the public release of SQL Server Denali CTP1, the product team demonstrated a replacement for SQL Server Profiler built on top of Extended Events. The writing is on the wall for SQL Trace, and the future of diagnostic profiling in SQL Server is Extended Events. Extended Events provide more information about the operations of SQL Server than have ever before been available in the product. Unfortunately, there is a significant learning gap between Extended Events and SQL Trace, and the lack of a UI has only made the learning curve that much steeper. This session will introduce you to the basics of Extended Events and how they will redefine diagnostic data collection in SQL Server. It will then demonstrate the depth of information available with Extended Events through example Event Sessions.
About the Speaker:
Jonathan Kehayias is a Senior Consultant with SQLskills and the youngest person to achieve the Microsoft Certified Master - SQL Server 2008 certification. A SQL Server MVP for many years, Jonathan is heavily involved in the SQL community as an active expert on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog), and answering questions as @SQLPoolBoy on Twitter.
Jonathan is the world authority on Extended Events; he wrote the definitive whitepaper on Extended Events for Microsoft, authored the Extended Events Manager SSMS add-in, which won the PASS 2008 SQL Hero contest, and blogged a month-long series on Extended Events that illustrates practical uses for Extended Events in SQL Server 2008 and SQL Server Denali.