LSN在SQL Server中是什么意思? [英] What does LSN mean in SQL Server?

问题描述

日志序号是什么意思?我知道它是二进制类型，长度为10个字节，它对应于数据库中事务发生的时间.但这是以某种有效的二进制格式存储的高精度日期时间值，还是日期时间和其他东西的函数(例如，同一毫秒内发生的事务的序列号).我做了很多搜索，但找不到很好的答案.

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.

任何人都可以用公式或函数来解释，该公式或函数用于从日期时间或任何东西中导出LSN.

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

推荐答案

SQL Server中的每条记录 事务日志是唯一标识的 通过日志序列号(LSN). LSN 的命令是这样的，如果LSN2是 大于LSN1，变化 由引用的日志记录描述 由LSN2更改为 由日志记录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.

从此处.

您不必担心它们的产生方式.

You should not be concerned with how these are generated.

这篇关于LSN在SQL Server中是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！