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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-09 : 08:26:44
|
| ricky writes "One database called P42. SQL administrators decided to add datafiles as they think is needed as oppose to letting one datafile grow unrestrictedly in the last 2 years. I picked up the support for the server recently and been tasked to consolidate all 10 datafiles for this database P42 about 150G. I am in need of the proper process on how to do this. Please help. Thank you." |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-01-10 : 01:13:19
|
| Why do you want to consolidate all 10 datafiles back to 1? whats the reason for it? |
 |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-01-10 : 03:39:47
|
| The previous Administrator probably choose that route because Multiple Datafiles (Filegroups) help with balancing data load across multiple disks and they use parallel threads to improve data access which boils down to improved performance. But on the other hand too many filegroupgs can cause too many parallel threads can cause bottlenecksRegardsNIf you want your computer to be faster then throw it out of the window. |
|
|
|
|
|
|
Multiple datafiles