thanks for the link it was realy informative. I changed the setting after reading the artical.

My log fie is increasing a lot. 10MB every 8-9 seconds. What may be the reason.

I am reading the records from million rows and set updating one column in the same table at a time max of 10000 rows. This update is in begin tran and commit tran then why should the log file increas?

Note i have one index which has the updateable column in its inlcude list.