問(wèn)題描述

日志序列號(hào)是什么意思?我知道它是二進(jìn)制類型和 10 字節(jié)長(zhǎng)，它對(duì)應(yīng)于事務(wù)在 DB 中發(fā)生的時(shí)間.但這是一個(gè)以某種有效二進(jìn)制格式存儲(chǔ)的高精度日期時(shí)間值，還是日期時(shí)間和其他東西的函數(shù)(例如，在同一毫秒內(nèi)發(fā)生的事務(wù)序列號(hào)).我做了很多搜索，但找不到一個(gè)好的答案.

What is the meaning of Log Sequence Number? I know that it is of type binary and 10bytes long and it corresponds to the time the transaction happen in DB. But is this a high precision date-time value that is stored in some efficient binary format or is this a function of date-time and something else (for example the serial number of transactions that happen at the same milli second). I did a lot of searching but couldn't find a good answer to this.

任何人都可以用一個(gè)公式或函數(shù)來(lái)解釋，該公式或函數(shù)用于從日期-時(shí)間或其他任何東西推導(dǎo)出 LSN.

Can any one explain with a formula or function that is used to derive the LSN from date-time or anything.

推薦答案

SQL Server 中的每條記錄事務(wù)日志是唯一標(biāo)識(shí)的通過(guò)日志序列號(hào) (LSN).LSN排序使得如果 LSN2 是大于 LSN1，變化由引用的日志記錄描述到由 LSN2 發(fā)生更改后由日志記錄 LSN 描述.

Every record in the SQL Server transaction log is uniquely identified by a log sequence number (LSN). LSNs are ordered such that if LSN2 is greater than LSN1, the change described by the log record referred to by LSN2 occurred after the change described by the log record LSN.

來(lái)自這里.

您不應(yīng)該關(guān)心這些是如何生成的.

You should not be concerned with how these are generated.

這篇關(guān)于LSN 在 SQL Server 中是什么意思?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！