August 9, 2011 at 11:46 pm
Actually i deleted some rows from a table and load into the another table...This scenario is the continuous process...If i go like this Transaction logs will increase..I want to calculate how the growth will increase in the transaction logs?
August 10, 2011 at 5:38 am
depending upon your recovery model the t-log will clear periodically or with your backups. a checkpoint will help but an open transaction will stop the log clearing from before the open tran. I usually assume log space used will be twice the size of what I'm working with, as a rule of thumb. I usually work on a t-log being between 40 and 50% of the size of the actually database to allow for dbcc, index rebuilds and so on.
Hope this helps.
ps. using simple recovery sometimes the log doesn't clear as quick as you might expect - issue a checkpoint after your delete to help it along.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply