I've seen it mentioned a few times that you can configure an event session to take an action when an event fires. Does anyone have any information on how to do this? I know that you can use the service broker to take an action on an event, but I don't consider that to be part of an event session.


Erin Stellato's Stairway to Extended Events is a good starting point here (it's behind a registration wall, but it's worth it.) She explains how you can use the SSMS GUI to create an Extended Events session that will trigger a dump, for example.

Understand that taking an action like creating a dump will be very performance-intensive.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.