-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?

  • 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? – Erik Darling Apr 6 '17 at 18:04
  • As @sp_BlitzErik noted, you are in a perfect position to test this. – Max Vernon Apr 6 '17 at 20:32
  • Yes if I could currently access the instance of SQL server – mheptinstall Apr 6 '17 at 20:37
0

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, privacy policy and cookie policy

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