March 4, 2013 at 7:05 am
Hi,
I'm getting a new server this week and have some say in the disk configuration. Basically i've got 2 600GB SAS drives configured in RAID1 for the OS (Windows Server 2008R2 64Bit Std). I've then got 12 7.2k SAS disks for the data/logs giving 6TB of storage.
My question is this....
Is there any performance advantage to be had by separating logs from data files. This is going to be a data warehousing server...
Ignoring the OS partition because there's nothing i can really do there....
Is it more sensible to have
a) 4 disks in a RAID 10 config for logs and then 8 disks in RAID 10 for Data?
b) 12 disks in RAID 10 and have data and logs on the same drives?
With regards to TempDB what would you do? Put it on the faster OS disks? or split it amongst the 4/8 or 12 disk configs?
Thanks for your help!
Simon
March 4, 2013 at 10:48 am
with that few spindles I would simply do a 12-disk RAID10 set and drop everything on it. Spindle-aggregation is usually a good thing. I have had good success with that, and have run into problems at clients that have carved up a bunch of 2 and 4 disk sets causing bottlenecks. I acknowledge there is a flip side here too.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 5, 2013 at 2:04 am
Great thanks for your help. That was the option i was leaning towards.
March 11, 2013 at 5:14 am
Aside what Kevin has said, what size are the 12 x SAS drives?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply