January 25, 2016 at 10:41 pm
On a SQL Server, at any point of time, do all the transactions happening on the server will be written on multiple VLFs? Is it possible? In that case, how does the server determine what is the MaxLSN as the LSN is spanned over multiple VLFs?
January 26, 2016 at 1:57 am
No. One at a time. The LSN is an always-increasing value, so if SQL starts using a VLF, it can't go back and write to an earlier one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2016 at 7:05 am
I you want to read up on this then here is a quality TechNet article by Paul Randal. Half way down the article is all about the Transaction Log and LSNs.. enjoy!
https://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx#id0060041"> https://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx#id0060041
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply