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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2009-02-05 : 18:10:58
|
| Just a general filegroup question. If you don't have multiple disk drives to spread the data across, is there any advantage to using multiple filegroups, or should you just go with the primary filegroup? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-02-05 : 18:32:27
|
| The answer is.....it dependshow much dtaa are we talking about?In general multiple files across drives increases performanceMultiple files on the same drive should also, but not as muchA single file with small amounts of data should probably perform just as well as the other 2Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2009-02-06 : 08:00:06
|
| db size is around 10g. If you have multiple filegroups, is there an optimum size the datafiles should be? |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-02-24 : 05:05:05
|
quote:
Originally posted by helpme
Just a general filegroup question. If you don't have multiple disk drives to spread the data across, is there any advantage to using multiple filegroups, or should you just go with the primary filegroup?
Multiples filegroups in a same drive will help in having a good restore strategy as u can backup independent filegroup, however I dont think that it will increase performance bcoz theres only one drive head available...Regards,Ahmad Osama |
|
|
|
|
|
|
multiple filegroups or primary