© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_27

27. Extended Events

Dmitri Korotkevitch

(1)Tampa, Florida, USA

Extended Events is a highly scalable performance monitoring and troubleshooting solution introduced in SQL Server 2008. It is targeted as a replacement for SQL Traces, which was deprecated in SQL Server 2012. Extended Events are lightweight, and they have the flexibility to allow for troubleshooting of some scenarios that were not possible with SQL Traces.

This chapter provides an overview of the Extended Events framework and shows you how to work with them.

Extended Events Overview

Even though SQL Traces events are extremely easy to set up, they have serious limitations. All event types ...

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