I’ve been looking on how the connector of Debezium
for MSSQL
works under the hood, but I’m not sure I’ve understood it correctly.
On the docs, section about the snapshots
(see https://debezium.io/documentation/reference/stable/connectors/sqlserver.html) it says
4. 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