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?