Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
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.
