COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: mnennig on 23 Nov 2015 11:56:04 AM

Title: IBM AuditDBCleanup tool affect on database
Post by: mnennig on 23 Nov 2015 11:56:04 AM
Looking to use the IBM AuditDBCleanup tool against the 10.2 log database on SQL Server.  Expecting to remove about half of a 13 GB log file.  How much of a performance hit on database can be expected?  Should this only be run during off hours?
Title: Re: IBM AuditDBCleanup tool affect on database
Post by: Yizi on 25 Nov 2015 02:11:48 AM
Simply run it when database is not needed, it doesn't effect the DB as much (depends how big it is).