SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Respository Database Size

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Respository Database Size
Author Message
Akinja Richards



Joined: 21 Sep 2005
Posts: 6

Post Respository Database Size Reply with quote

I noticed my repository database has grown to about 19Gb. On this server, I have 35 databases, not including the system dbs. The table that has grown is sys_audit_trail. Although there are 35 databases on this server, I am only monitoring 3 but plan to expand this number. I don't know if the size and lack of indexes are the but any sys_audit report takes a long time (if ever) to return. Currenly there are almost 30 million rows in this table.

I understand that I can truncate the table, but what will that do to any history I want to recover?

Fri Oct 07, 2005 10:54 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Re: Respository Database Size Reply with quote

This sounds like you are having active databases with lots of activity or data changes for which you have enabled the auditing.

To control the volume of audit data you can narrow the scope of events that you want to audit and/or setup automate purge procedures that delete old audit records. Both options are available in DB Audit GUI.

: I noticed my repository database has grown to about 19Gb. On this server, I
: have 35 databases, not including the system dbs. The table that has grown
: is sys_audit_trail. Although there are 35 databases on this server, I am
: only monitoring 3 but plan to expand this number. I don't know if the size
: and lack of indexes are the but any sys_audit report takes a long time (if
: ever) to return. Currenly there are almost 30 million rows in this table.

: I understand that I can truncate the table, but what will that do to any
: history I want to recover?

Fri Oct 07, 2005 12:25 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.