SQL Server uses a proportional fill method to add data to file groups where
a file group has multiple files. In general this is a good thing.
Unfortunately, the method appears to get switched off when new file(s) is
added. Other than exporting the data out of the filegroup, recreating the
filegroup and putting the data back in, is there a way to respread the
existing data back out and switching the proportional fill method back on?
Thanks,
DannyAs far as I know, there's no way to influence where MSSQL places data
within a filegroup. I'm not sure what you mean by "switched off" - if
you can give more details of what you're seeing, and what problem it
causes, then someone may have a suggestion.
Simon|||You can not turn this behavior off. I think what you mean is that when you
add a file to the filegroup the data is not re-balanced to evenly distribute
the data across all files including the new one. This is the way the system
is designed. You would have to force it by rebuilding indexes, but this
introduces a space requirement and a period in which the table is offline
during the rebuild.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"Danny" <someone@.nowhere.com> wrote in message
news:9dRke.1781$5T2.877@.trnddc01...
> All,
> SQL Server uses a proportional fill method to add data to file groups
> where a file group has multiple files. In general this is a good thing.
> Unfortunately, the method appears to get switched off when new file(s) is
> added. Other than exporting the data out of the filegroup, recreating the
> filegroup and putting the data back in, is there a way to respread the
> existing data back out and switching the proportional fill method back on?
> Thanks,
> Danny
No comments:
Post a Comment