What happens to proportinal fill once data files reach their limit?
0
votes
1
answer
105
views
Taking the example of data files (user db or temp db), assuming initial db size is 1GB and we have 3 data files.
Proportional fill will allow data to enter into the 3 files such that it allow max parallelism because of proportional fill algorithm.
However, once the data reaches 1GB in each file, and assuming auto growth is set to 100MB, then will proportionally fill algorithm stop working because only 1 file's 100MB is available (free) for use?
Is there way around this for example by growing all data files together by 100MB even when only 1 of them is full?
Asked by variable
(3590 rep)
Mar 8, 2022, 07:34 AM
Last activity: Mar 9, 2022, 07:41 AM
Last activity: Mar 9, 2022, 07:41 AM