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 |
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
 Posted - 2007-11-01 : 07:23:45
|
| The number of data files within a single filegroup should equal to the number of CPU cores. So for a quad core CPU there should be 4 data files. Is there anything that one need to take care besides creating the data files for a filegroup. I belieev SQL takes care of itself how to update data files . |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-01 : 09:32:18
|
You need to make sure you create each data file with the same file size.
Future guru in the making. |
 |
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-11-01 : 09:42:04
|
| Ok we create the data files of same size . But will autogrowth take care off itself . Just to clarify it will distribute data across datafiles and not duplicate data (thereby not leading to increased storage requirements ) . |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-01 : 10:24:57
|
When the files are the same initial size the file growth will occur in a round robin fashion.
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 22:51:16
|
| What do you mean 'duplicate data'? Sql will not store multiple copy of data in those files. |
|
|
|
Hitesh Shah
Yak Posting Veteran
80 Posts |
Posted - 2007-11-02 : 00:07:03
|
| I did know about that . But I wanted an opinion of an expert and experienced one on this. |
|
|
|
|
|
|
quad core