Sample Header Ad - 728x90

MSSQL - How to log every rpc_completed event into a table?

0 votes
1 answer
225 views
I want to log the Execution Time and Parameters for every stored procedure call on my database. What I reached by searching is to use extended events as the latest method with minimum performance overhead. My aim is to achieve a similar result as the 'rpc_completed' event of 'extended events', but the problem with using extended events is that their sessions log output into .xe* files and there is no option to choose a database table as far as I read from tutorials/docs. Can I (by any means), redirect extended events logs to a database table synchronously? I can sacrifice hardware resources for this, but can't pick methods like triggering interval-ed queries to read from *.xe files and insert them into a database table
Asked by behnam-io (1 rep)
Apr 22, 2021, 05:52 AM
Last activity: Jun 14, 2025, 03:08 AM