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
VitaminDAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Surendra NathConnect With a Mentor Technology LeadCommented:
I think this is just regular behaviour, a more detailed description is here
http://sqlmag.com/blog/rebalancing-data-across-files-filegroup
0
 
Eugene ZCommented:
as per above post, it is normal for user DB -- try to limit SIZE of old file

also adjust as needed  auto growth settings for files

read

Round Robin, Proportional Fill and Performance Considerations
http://sqlserver-performance-tuning.net/?p=2552
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.