Post reply

which is the best Raid Configuration for Transaction Logs

  • June 1, 2006 at 3:06 am

    #169722

    I am in the process of  configuring a server to run Enterprise edition, there will be multiple instances on this server with several third party vendor solutions running. Here's my dillemma

    Transactions Logs: I know that raid1 is a good choice for the transaction log transaction log if you have a single databse app on a server. but is it okay to allow a single raid1 array for several transaction logs?  I have a choice for of the above or to use a raid5 array for the logs.

    I also would like to put the tempdbs from each instance on a shared raid1 array - is that feasible

     

  • June 1, 2006 at 4:28 am

    #641126

    Paul

    I would stick with RAID1, even if you have logs from more than one database/instance on it.  The reason is that RAID5 is good for reads, but is slower for writes because there is an overhead in writing the parity bit.  The same goes for tempdb.

    John

  • June 1, 2006 at 8:24 am

    #641195

    The log writes linearly. Depending on the disks and log access, putting more than one on a single pair of disks can be slow.

    I like RAID 0+1, though I've run 1 with more than one set of logs on there.

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

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