I had a drive running low on disk space where the mdf resides, so I created a new ndf file on the Primary filegroup on a different drive.
How do you know when it's being written too? Are there any queries that can tell you that? How does it distribute(balance) so original drive doesn't completely run out of space?
Thanks.
When you add a file to a filegroup - SQL Server uses a proportional fill algorithm. Here is some information you can review:
https://www.sqlskills.com/blogs/paul/investigating-the-proportional-fill-algorithm/
Basically, since you added a new file and that file probably has a lot more space available than the existing file it will get most of the new data being added. The ideal solution is to have multiple files that are all the same size and have the same space available - that way data is spread evenly across all files.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 25, 2024 at 5:26 pm
Thanks for info.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply