Audit universe slow performance issue

[Former Member]

Last year I activated audit options so I could create reports based on Activity universe.

Everything was fine at the beginning but sometimes happens that my Activity reports seem to run very slowly and sometimes they run fast. I don't know why does it happen.

Could it be that Audit database has too many rows in the session related tables?

Does Audit database need some kind of periodical maintenance?

[Former Member · Accepted solution]

All reports requirement maintenance.

Have a chat with your DBA - indexes and stats being the two easiest things to sort out.

It could also simply be row locking at times - you're accessing data that is in the process of being written to.

[Former Member · Accepted solution]

That could be what is happening, it makes sense.

However, I'm not sure if I can modify Bo audit database because it comes with BO installation, it's not a database created by me.

Edited by: PadawanGirl on May 27, 2011 4:14 PM

[Former Member · Accepted solution]

You're not modifying the structure, you're simply adding an index or two and tuning it a bit.

If it's on SQL Server then you'll be able to run an explain plan in SSMS of the generated query SQL and see what the bottlenecks are.

This section on the MS kb should help: http://msdn.microsoft.com/en-us/library/ms176005.aspx