Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-08-23 : 03:46:07
|
| Hi experts,In SQL Server 2005 database we have partitioned a very big table into 30 partitions each holding few million of records.Im just curious to know whether there are some configuration related to processors or system hardware in order to benefit from partitioning ? (Ex : If we have multiple processors Whether they need be configured to do a parallel processing ? )Any real time experience (other than referring links) would be really helpful for me.Thanks in advance,Hariarul |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 22:55:36
|
| We put filegroups of partitioned table in separate disk arrays. |
 |
|
|
|
|
|
Configurations for partitions.