Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

So I am pretty green when it comes to hardware configurations.

I just asked a coworker and he said we're using RAID 60 (I assume is the same as RAID 6+0).

I am doing some tests on a large table (1 billion rows), and setup a different partition for each day of data. From what I understand I would want to ideally put each partition on a separate filegroup and each filegroup would get its own dedicated disk.

Am I right that creating "virtual" drives for each FG is not going to make a difference since all of the storage is coming off of a RAID 60 "device"?

Is there anything I can do to improve disk performance when creating an index on a table of this size?

share|improve this question

migrated from stackoverflow.com Dec 9 '10 at 2:41

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer

Am I right that creating "virtual" drives for each FG is not going to make a difference since all of the storage is coming off of a RAID 60 "device"?

Yes you are absolutely right. That data is already striped all over that array.

Is there anything I can do to improve disk performance when creating an index on a table of this size?

Unless you have control over the hardware and RAID setup, there is nothing you can do. CREATE INDEX will run in parallel with Enterprise Ed but that is on by default anyway.

share|improve this answer
    
Thanks Jack, it was not as bad as I anticipated, finishing in 1 hour, over 1 billion records, for 6 columns. –  nycgags Dec 8 '10 at 21:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.