Adding a new data/log file

Question

Adding a new data/log file

loiter99

SSC Enthusiast

Points: 109
More actions
December 30, 2003 at 9:26 am

#160444

Hello,
Once a new data file is added, when will the server start storing data in the new file/log ?
Thanks
J
Edited by - loiter99 on 12/30/2003 09:26:07 AM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mimorr SSCarpal Tunnel Points: 4850 More actions · Answer 1

Yes. If you add a file to a filegroup, then SQL starts filling both files.

I believe adding a second log file works the same way, SQL starts splitting the load. However, from past experience, I would be careful with having more than one log file.

Michelle

ChrisMoix SSCommitted Points: 1568 More actions · Answer 2

SQL Server Does Not split the I/O between the transaction log files. It writes to them sequentially, filling the first one, then the second. There is no performance to benefit having more than one t-log file.

sxg6023 SSCrazy Points: 2918 More actions · Answer 3

Set a limit on the max file size of the current file to force all your data to the

new file immediately.

I am curious of new log file usage. Since it is sequential, should it not fill

the first one before it starts using the second one?

ChrisMoix SSCommitted Points: 1568 More actions · Answer 4

quote:
Set a limit on the max file size of the current file to force all your data to the
new file immediately.
I am curious of new log file usage. Since it is sequential, should it not fill
the first one before it starts using the second one?

That's exactly right. The only thing that a second log file buys you is more disk space (if you are running low on disk space on your t-log disk, you can add another transaction log file on another disk and keep from having to perform a t-log backup or truncating the log). It will not split writes between two files.