Extended events, abbreviated as XEvents, is a built-in auditing and monitoring functionality available via SQL Server Management Studio GUI or SQL scripts. You can set up and configure it to capture pretty much anything that happens on SQL Server. It’s quite flexible and fairly easy to set up.
Extended events was intended as a replacement for Profiler , which was supposed to be deprecated in some future SQL Server version. Profiler is a way to create a trace that can capture everything ...
Get Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance 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.
Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.
Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.
Start your free trial Become a member now