Solved

New NDF File

Posted on 2014-01-06
2
230 Views
Last Modified: 2014-01-23
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
0
Comment
Question by:VitaminD
2 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
ID: 39761289
I think this is just regular behaviour, a more detailed description is here
http://sqlmag.com/blog/rebalancing-data-across-files-filegroup
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 39761695
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

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now