Chapter 17. Using Extended Events
I introduced you to Extended Events in chapter 13, where we used them to capture information on blocked processes. Now, I’d like to dig deeper into Extended Events with some very specific (and super-useful) scenarios. We’ll walk through how the technology works, get it set up for various purposes, and look at what it can provide you.
17.1. What are Extended Events?
As I described earlier, Extended Events is a native SQL Server technology that allows for continuous monitoring and capturing of specific things happening on the server. You create a session that monitors for whatever events you’re interested in, and it logs information from those events when they occur. You can then review those logs at your leisure. ...
Get Learn SQL Server Administration in a Month of Lunches 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.
