In a previous question, it was suggested that I should add an extra "File" to my existing (Primary) Filegroup to easily add more disk space for my DB.
So I did that and nothing broke.
But I'm not sure when Sql Server will decide to stop putting data into the original File and start putting data over to the new File?
From @davidbrowne's excellent answer to my question, he mentioned:
SQL Server uses a "proportional fill algorithm" when a filegroup has multiple files.
Okay, great - but when does it 'know' to start filling the other file?
Currently, this is what I have setup ... and please note the MAX FILE SIZE.
Do I need to give a MAX file size (e.g. LIMIT to 1T) for the original File which will then help Sql Server to 'know' when to start using the next (new) File?
There's currently 19GB left on disk