What is an LSN and how is it used?

An LSN (Log Sequence Number) is a unique log record identifier and is equivalent to the Log Address of the record. Page states are tracked by their LSNs. Whenever a page is updated, the LSN of the log record that describes the update is written to the page. The LSN, therefore, indicates the chronological state of the page. ... more