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.
Sql-server – Take action from extended event
extended-eventsservice-brokersql serversql server 2014sql-server-2012
Best Answer
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.