SQL Server Performance Forum – Threads Archive

Log Flushes/sec

I’m seeing about 300 log flushes per second in one of my load proccesses I’m basicly doing a bunch of sproc calls to insert statements is there a way to control when the flushes occur for ex: begin trans
Insert INTO
Insert INTO
……
commit trans will cause one flush as opposed to one per insert Statement is this better for performance the single insert statements with no explicit transactions?

---

Yes this is better for performance, it will reduce log flushes. Be careful that you do not have massively large transactions though, keep enough transaction log space to accomodate this. Batching your Insert statements would help to reduce network round trips if your processing a lot of statements. If you could perform a bulk insert to insert all the data in one operation it would give the best performance in all areas.

---

]]>