|
Home > Archive > MS SQL Data Warehousing > September 2005 > File and File Group
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
File and File Group
|
|
| Travis 2005-09-19, 3:23 am |
| Hi ,
What is the diffence I create 1 file on the same disk under 1 file group
and
multiple files on same disk under 1 file group ?
--
Travis Tan
| |
|
| In short not much. The number of files in a file group is largly determined
by three factors.
Flexibility of distributing data. Spreading data across multiple disks.
Easy of maintenance. One file is far easier to manage because you won't be
dealing with proportional fill.
Number of processors on your server. Technically you can get a small gain
by having at least one file per processor.
"Travis" <Travis@discussions.microsoft.com> wrote in message
news:26293D86-5918-4774-B5D7- 6DBE1B98EFA0@microso
ft.com...
> Hi ,
>
> What is the diffence I create 1 file on the same disk under 1 file group
> and
> multiple files on same disk under 1 file group ?
>
>
> --
> Travis Tan
|
|
|
|
|