Thanks for the clear explanation TheSQLGuru. I'm a beginner to the SQL Server world. For the moment nearly 300MB Log was ok for me. So I'll try that batch commit...

Changed the code adding BEGIN/COMMIT TRAN Block and increased the size of the transaction log into 300MB

1 Minute and 20 Seconds

Then write...

But AWE is not enabled in my machine. Anyway I'm planning to enable it as suggested and see the way server is behaving. Is 2040 hotfix?