CHAPTER 28

image

Extended Events

Extended Events is a highly scalable performance monitoring and troubleshooting solution introduced in SQL Server 2008. This chapter provides an overview of the Extended Events framework and shows you how to work with them.

Extended Events is targeted as a replacement for SQL Traces, which are deprecated in SQL Server 2012. Extended Events are lightweight, and they have the flexibility to allow for troubleshooting of some scenarios, which were not possible with SQL Traces. For example, capturing the first several occurrences of a specific event, obtaining session-level wait statistics, or detecting objects with a large ...

Get Pro SQL Server Internals 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.