January 12, 2007 at 7:28 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 12, 2007 at 8:59 am
one mdf made up of one file per socket or core. 6 disks have twice the throughput of 3 disks. I've rarely had to resort to using multiple mdf files and balancing performance on multiple mdf's can be time consuming - possible options where it might be better include data partitioning where one filegroup is read only.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply