title: How to capture actual execution plan in a deadlock graph?
body: <p>Is there any option or any setting by which SQL Server can dump the actual execution plan (at that instance) for stored procs involved in a deadlock?</p>
  
  <p>This is in context of SQL Server 2008. </p>