Has anyone with a large environment that has been running for over 6 months seen their audit reports slow down? I have a customer facing report that track the number of times users have run certain reports. This report is getting slower and slower and is terrible during the day as users are running reports and other trying to view the log information.
I have tried indexing the tables, and have even put a view out to report off of but reporting is still slow.
It has to be due to all the writes happening the same time the reads are on the logging tables.
Has anyone implemented a solution that solves this problem?
Thanks
Kevin