Skip to Content
Former Member
Nov 20, 2012 at 02:19 PM

SQL Server add additional data files data not evenly spread


I have a SAP system running on SQL Server 2008 R2. The database was originally setup for 4 data files and 1 log file.

We would like increase the CPUs to 8 and add an additional 4 data files to the database.

The SAP install by default put all data files in 1 filegroup called PRIMARY which is the default filegroup of a SQL Database.

So I will be adding the 4 new data files to the PRIMARY filegroup.

I have read that SQL Server uses proportional fill to fill that data files, so by add the additional 4 data files these will be filled

with most of the data resulting in the data no being spread evenly over all 8 data files.

Is there a SAP recommeded procedure for adding data files and making sure data is evenly distributed over all 8?