Build your first Extended Events session for slow SQL calls, choose a bounded ring buffer or file target, and read the captured result.
Replacing Profiler Traces With Extended Events
Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.
The Blocked Process Report
The blocked process report shows the waiting session and blocker after a configured threshold, with Extended Events capturing the XML for review.



