Showing results for 
Search instead for 
Did you mean: 

Are there any issues if 'Query' event tracking is enabled for Auditing?

0 Kudos

We have been making use of the Auditing database and Universe for BOE. We are unable to glean information about queries yet because we have not set this up yet in the CMC. There is a 'Query' event details checkbox that we have been hesitant to check because we are concerned it will blow out the size of the auditing database and slow the system (BI LaunchPad) down. If anyone has experience with this, I'd love to hear about it. Specifically interested in database size changes and performance impact. Also - when 'Query' is checked, are you able to get useful information from the auditing database/universe?

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor

Turning on the Query option in Audit will significantly increase the size of your audit database. With my clients, I usually only recommend turning it on when trying to diagnose a query issue in a report and then turning it off after running the report that's having an issue.