I’ve been looking on how the connector of Debezium for SQL Server works under the hood, but I’m not sure I’ve understood it correctly.
In the docs, in the section about the snapshots
(see https://debezium.io/documentation/reference/stable/connectors/sqlserver.html), it says
- Read the maximum log sequence number (LSN) position in the server’s transaction log.
How does it read the LSN
is not clear to me. Does it read it on the file level or from the server, by querying it with sys.fn_cdc_get_max_lsn()
? This query is called with a frequency as set in the polling
parameter?
Thanks