Chapter 24. Extended Events

After completing this chapter, you will be able to

  • Create and configure Extended Events sessions.

  • Use an Extended Events session to monitor system performance.

  • Analyze captured Extended Events data in SQL Server Management Studio.

Extended Events (or XEvents) is the next-generation tracing and troubleshooting architecture for SQL Server. If you’ve never heard of Extended Events before Microsoft SQL Server 2012, don’t worry, this chapter will provide a solid introduction to this highly flexible, user-configurable monitoring tool.

SQL Server Profiler is deprecated in SQL Server 2012, and SQL Trace will be replaced by the Extended Events system in a future version of SQL Server. Extended Events offers many advantages over the ...

Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.