January 12, 2007 at 7:27 am
Apologises,
didnt really know where to put this topic.
We are currenly deisgning a new server. My question is which setup do you think will give the best performance?
A) one mdf file on a disk array with 6 physical disks?
B) two mdf files on each array of 3 physical disks?
January 15, 2007 at 8:00 am
This was removed by the editor as SPAM
January 16, 2007 at 4:29 am
Its difficult to advise you without knowing the data patterns. I used to be a fan of faffing around trying to break out the databases/indexing/etc onto different drives. Now I just get the biggest stripe available. 6 disks in raid 10 is probably a good start, if you find that the disk qs are too long then grab some more disks and shift some stuff onto it. A rule of thumb is to have os, data and tlogs and backups on seperate drives - more for redundancy than anything else - it sucks to lose the tlogs as well as the data...
January 16, 2007 at 6:06 am
Ok, its raid 5 but, But ive got a raid 1 that I can put the ldf, backups, tempdb on, trans logs on.
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply