Post reply

1 transaction log or more

  • June 21, 2006 at 4:22 pm

    #61256

    Hello Everyone,

     

    I was just wondering if there are any performance gains by having multiple log files instead of having just one.

    My database is quite huge, 900Mb but it only has 1 transaction log file.

     

     

     

    Kindest Regards,

    John Burchel (Trainee Developer)

  • June 22, 2006 at 8:32 am

    #645275

    900 MB???? That's NOT huge. One of my databases is (as of today) 292 GB and it grows 2 GB every day. I only have one transaction log file and don't have any problems. However, it is good practice to have your tlog on a separate drive from the data files.

    -SQLBill

  • June 22, 2006 at 9:46 am

    #645302

    I agree that one log works ok. Multiple data files can sometimes perform better because multiple threads are used for access, but since logs are written sequentially, not sure it helps there.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply