Best Config For Two Disks

Question

Post reply

Best Config For Two Disks

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

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

Brandie Tarvin SSC Guru Points: 172918 More actions · Answer 1

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.

matt stockham SSCrazy Eights Points: 9942 More actions · Answer 2

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.