I am seeking to understand what the ideal latency for an implementation of CDC in SQL Server Standard (2017) is.

The latency I am referring to can be found from the sys.dm_cdc_log_scan_sessions DMV outlined here.

The polling interval for this implement is equal to 1 day (86400 seconds) and continuous mode is being used as both shown from the sys.sp_cdc_help_jobs table.

I know the latency is defined as "The difference, in seconds, between end_time and last_commit_cdc_time in the session" but I am still struggling to understand what is considered an ideal latency.

I would imagine it would be either be near 0 as most ideal latencies are or it is ideally near the polling interval.

Please and thank you

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.