asked on New NDF File
I added another ndf file within an existing Filegroup on another drive.
I allocated about 3 GB as an initial size.
The new file is still not filling up.
No data is going to the new file only to the old file.
The old file has not grown much not sure if this is why it is not filling up the new file.
Any input would be appreciated
Thanks In Advance
I allocated about 3 GB as an initial size.
The new file is still not filling up.
No data is going to the new file only to the old file.
The old file has not grown much not sure if this is why it is not filling up the new file.
Any input would be appreciated
Thanks In Advance
Microsoft SQL Server
Last Comment
EugeneZ
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
also adjust as needed auto growth settings for files
read
Round Robin, Proportional Fill and Performance Considerations
http://sqlserver-performance-tuning.net/?p=2552