• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 560
  • Last Modified:

table partition on SQL 2008 R2 - question

Hi Experts

i have a table in production which will hold for a year between 40000000-120000000 records.
i thought to make a partition of this table for each 10,000,000 records.

i have only 1 disk to use on this server.
do i need  12 files group or can i do it with 12 files on the same file group for each range?

i don't find answer for that and would like to hear some other opinion.

10x
0
gudidi
Asked:
gudidi
  • 3
  • 2
1 Solution
 
mayank_joshiCommented:
you can do it both ways.it depends on how you define the partition scheme.
0
 
gudidiAuthor Commented:
what is better?
12 files group with one file each
or 1 file group with 12 files?
0
 
mayank_joshiCommented:
In a Partition Scheme, you can define that all partitions are mapped to the same filegroup, or you can use the scheme to split up the partitions across filegroups. The advantage is that, when the filegroups are split across individual disks, SQL Server will be better equipped to use resources when retrieving data. This advantage becomes even greater when you are running queries against the partitioned tables on a server with multiple processors.
0
 
gudidiAuthor Commented:
10x
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now