Post reply

Best Config For Two Disks

  • November 20, 2007 at 9:00 am

    #752761

    Or, would you break the mirror and use 4 disks to create a Raid 1+0 and then the other three disks for Raid 5 (for TempDB & the user logs)?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • November 20, 2007 at 9:34 am

    #752778

    I would keep 4 drives in raid 10 (user DBs, tempdb), use 2 drives in raid 1 (logs), maybe use the other drive to mirror the OS drive (assuming it is currently a single disk) or as a spare. That way the system can survive any one drive failure. An alternative might be to use raid 5 instead of raid 10 if there is very little write activity, but given the size of the databases I would expect the data to be largely cached anyway.

Viewing 2 posts - 16 through 16 (of 16 total)

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