November 15, 2006 at 7:31 am
I have an environment where I run several DTS import processes during the day - Each process currently brings in approx 1.5 million records into its own separate table. The database uses Reporting Services to generate Web Reports that use Views ( basically concatenate several tables together(date related)). The issue that comes along is that the transaction logging appears to take ages and the bigger issue is the database backup now takes ages to run. When the backup runs the database slows way down.
Can anyone give some recommendations on what I should be looking at to improve performance and reduce the Backup process from hogging much of the CPU .
What is the best logging option?
Should I backup before import process then use truncate log immediately after the and before the nightly backup is performed.
Any recommendations will be greatly appreciated.
Thanks
** What you see, Depends on what you Thought, Before, You looked! **
November 20, 2006 at 8:00 am
This was removed by the editor as SPAM
November 21, 2006 at 6:46 am
I would concur with your analysis. If you decide that your ability to redo an import is easier and quicker than the tradeoff of having to fully log the import process (and I believe it is, at least is was for me in a similar situation) then move to the simplest logging and truncate before and after your import process. Hopefully you'll see decent, if not dramatic, performance imporvement.
Regards,
Matt
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply