05-01-2011 09:16 PM
Solved! Go to Solution.
05-03-2011 10:42 PM
Just checked in my ev10 test environment: The AuditTrail table also does not have any indices. I'd suggest that you create an idea via the link posted earlier.
05-01-2011 09:31 PM
Could you post the query you are using?
A
05-01-2011 11:32 PM
05-02-2011 12:43 AM
The Audit DB can grow very large in a short amount of time on a busy system. So it might be necessary to truncate data from it or create a new DB.
Have a look at this technote: http://www.symantec.com/business/support/index?page=content&id=TECH35746
05-02-2011 01:01 AM
05-02-2011 01:09 AM
You could put the Audit DB on another server so that at least your productive EV Databases are not affected by poor performance or low disk space.
Regarding your support: This is correct, if you make any database changes that are not described by symantec it might be that a technician refers to this modification as possible reason and you will get no support. However: The Audit DB is simply a log DB and EV will run correctly without one.
This means: Should adding indices or creating views really lead to any problems with the auditing itself it should not affect ev production at all (besides that audit entries might be lost). You should always be able to simply delete it or to recover a backup of this particular database to revert changes.
05-02-2011 01:19 AM
05-02-2011 01:35 AM
Thats correct, putting the DB on another server does not solve the problem, it would only be a mitigation of the side effects.
You do not need full recovery mode for the audit DB as you would have no real advantage of being able to perform a point in time recovery. In fact almost all of our customers have simple recovery mode configured as a point in time recovery using logs will most certainly inconsistant (because the backup mode is not enabled).
05-02-2011 03:47 AM
05-03-2011 04:27 PM
05-03-2011 10:05 PM
I am not aware of any planned changes on this behaviour. EV 10 is out in beta but idk if something was changed regarding auditing there. I might be able to have a look at a beta test system later that day.
You could however post an idea to add indices here: https://www-secure.symantec.com/connect/backup-and-archiving/ideas
05-03-2011 10:42 PM
Just checked in my ev10 test environment: The AuditTrail table also does not have any indices. I'd suggest that you create an idea via the link posted earlier.