Tracing & Monitoring with SQL Server 2012 Extended Events

Extended Events, although in the product since SQL Server 2008, so far have only been known and used by experts as extremely lightweight and flexible tracing-framework in SQL Server. With SQL 2012 this important feature, that will replace SQL Trace & Profiler, finally gets its GUI. Here you will get to know the architecture and basics of extended event sessions and then learn how they give you completely new possibilities for troubleshooting and tracing in general. You will understand the built-in sessions that SQL Server 2008 and 2012 ship with and see some real-world application
use-case. You
will never use TraceFlag 1222 for capturing deadlock-information once you know what’s already inside SQL Server, ready to be pulled out.
Presented by Andreas Wolter at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Andreas_Wolter.jpg

    Andreas Wolter is both a Microsoft Certified Master (MCM) on SQL Server 2008 and a Microsoft Certified Solutions Master Data Platform (MCSM) SQL Server 2012 and has also been awarded with the MVP for SQL Server. He is the founder of Sarpedon Quality Lab, a Germany-based company that specializes in Development and Optimization of SQL Server Database- and Datawarehouse-architectures with focus on performance and scalability as well as a special passion for security. With over a decade of experience with SQL Server he can be met at various international conferences and delivering training for the SQL Server Master-Class seminar-series held in Europe. You can follow him at Twitter at @AndreasWolter.

    http://www.insidesql.org/blogs/andreaswolter/ http://www.insidesql.org/blogs/andreaswolter/?tempskin=_rss2
  • Video
    The video is not available to view online.