0

My goal: Use SQL Extended Event to perform Audit (strictly using Standard Edition, not Enterprise)

From previous post, I am able to capture and view the sql statement logged by the Extended Event. However, the event has so many redundant fields, such that it makes the .xel file really big (around 4x the original table for 100,000 new inserts)

enter image description here

The image attached shows all the columns captured. As observed, there are numerous fields: attach_activity_id.guid, client_app_name, cpu_time, ... etc I was thinking this is supposed configure-able. However, it seems that, there is no checkbox in the configure page, as shown below:

enter image description here

Is it possible to reduce the fields? (basically i only need client_app_name and statement)

Improve this question

1 Answer 1

Reset to default
4

I'm going to say you are getting all the extra fields because you picked a template when you built your event session (or used the wizard). If you only want certain fields then go uncheck what you don't want. However, there will be some event level info that will always be there, what is shown under the "Event Fields" for each event are their by default and cannot be removed.

Default event for "sql_statement_completed" only captures this, after I checked the global field for client application name: enter image description here

Improve this answer

Your Answer

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

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