Thank for the link. Auto growth was 10% every few second it was increasing the log. After i chnaged it to few mb the perfeomce has improved.

i have following code -

while 1=1

begin

begin tran

delete top 1000

where primarkkeycol = @variable

out out to deletehistory

if @@row count < 1000

break

commit tran

end

Out table(delete history) is also in the same noticed that in this case it now increasing temp db log and data. if log. if i am deleting records and adding same infor in other table why should the data log should increase

Also there is commit tran after 1000 records in process breaks then it takes long time to recover.