1

Using extended events I plan to capture stored procedure executions particular the time of execution, duration and who executed it.

Is the module_end event enough to capture this data? In a test session I have created I don't see what more the module_start event would provide though would a module_end event occur if a stored procedure execution is terminated?

3
  • 1
    Since you have an XE session running (that you didn't show us a definition for), why don't you just try killing a stored procedure while it's running to see what happens? Apr 6, 2017 at 18:04
  • As @sp_BlitzErik noted, you are in a perfect position to test this.
    – Hannah Vernon
    Apr 6, 2017 at 20:32
  • Yes if I could currently access the instance of SQL server Apr 6, 2017 at 20:37

1 Answer 1

2

To answer my own question - when a stored procedure execution is aborted then this is logged as an event, in which case I don't see the need to capture both module_start and module_end events for my purpose.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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