To resolve this issue try one of the following solutions:
1) Disk with better performance is recommended here to process the events with more speed
2) Configuring advanced data collection settings – Gather frequency. This interval regulates the frequency of a session file being filled with the SQL Server events. Increasing this value will change the period of data collecting from active event files (with a higher value, sessions will load more slowly thus less space will be occupied)
Set "Gather frequency" interval to 1 minute. There is an option to go up to 5 minutes but data will come in slower pace due to this extended interval so those high intervals should be avoided
To edit this setting run ApexSQL Audit GUI | Configure | select SQL Server from Server panel on the left | Edit | Show more options | Set the new "Gather frequency" interval | Click the OK button to save the changes
3) Audited events cannot/must not be reduced/deleted
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center