DZone Database Zone
Virtual Log Files: 200 or 1000?
Last week, I had the privilege of reviewing possibly the best SQL Server production environment I've seen in Canada. During the follow-up meeting, the senior DBA and I had a discussion about Virtual Log Files (VLFs), disagreeing on the maximum number of Virtual Log Files a transaction log should have. I said 200, and he said 1000.
Both numbers are arbitrary, so let's explore why VLFs exist and why we might prefer one over the other.
No comments:
Post a Comment