April 5, 2011 at 9:27 am
There is a job running that does an INSERT of all rows from a view into a table.
The transaction log is growing out of control because of this job.
If I had them create an SSIS job to EXPORT the data from a view to the table, would that have the same effect on the transaction log?
April 5, 2011 at 9:34 am
Carol,
Have you tried to use Bulk Insert, setting a batch size?
This will control the growth of the T-Log as well as potentially increase performance of your insert
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
April 5, 2011 at 9:37 am
I am not the one who wrote the job, but i am the one who is charge of the server and the backups and logs...I never thought about BULK INSERT. Thanks for the idea. I want to have a few recommendations before I go to the developer.
Very Appreciative!
Thank you.
April 5, 2011 at 9:40 am
Good luck
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy