| Author |
Topic |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2012-06-07 : 16:52:27
|
| question. i have a table that is around 800 million records. i was using partitioning w/ an incrementing identity column to split it across 8 file groups (8 different disks) but far-passed the qty for the last disk, so now all new data is on the last disk. is there any way to design the table/db in a manner so that once all of the disks in the partition are full, it starts back at the beginning of the chain? i basically would like it to evenly distribute the data across all 8 disks and auto grow. probably a really NUB question, and a simple answer, but not sure what to do here. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2012-06-07 : 16:58:41
|
| so you would just have one filegroup, and have it sitting on a raid5 or something? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2012-06-07 : 17:05:04
|
| so sql basically will auto-balance it if you have nothing explicitly setup? (like i would w/ partitioning) is that correct? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2012-06-07 : 17:28:07
|
| perfect, i'll try that. thanks! |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2012-06-07 : 17:46:09
|
| can you give me a sample db create script for one file group, two files with two separate mount points? i'm playing with the wizard and i'm a little lost, the script would probably spell it out for me. |
|
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2012-06-07 : 18:01:52
|
| O_o n/m i see... i flipped files/groups :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
file groups / partitioning questions