SQL Server Performance

Log Flushes/sec

Discussion in 'T-SQL Performance Tuning for Developers' started by BigJimSlade, Feb 26, 2003.

  1. BigJimSlade New Member

    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?
  2. seasider New Member

    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.

Share This Page