Extended Events

Extended Events (also called xEvents or simply XE) are intended for event monitoring. It sounds very similar to the job done by SQL Server Profiler, but xEvents are a modern tool using native eventing features of SQL Server, hence the resource consumption is much less than requirements requested by SQL Server Profiler.

Frugality is not the only advantage of xEvents. Unlike SQL Server Profiler, xEvents can capture events provided by new features such as R Services.

The third big advantage of xEvents is that the definitions are saved into SQL Server's metadata so the configuration of xEvents session made by a DBA is not done repeatedly. Once the xEvents session is created, the session could be started and stopped on demand from ...

Get SQL Server 2017 Administrator's Guide 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.