Question

Which of the following query returns the average latency for the most recent sessions?

(a) SELECT latency FROM sys.dm_cdc_log_audit_sessions WHERE session_id = 0

(b) SELECT latency FROM sys.dm_cdc_log_scan_ WHERE session_id = 0

(c) SELECT latency FROM sys.dm_cdc_audit_scan_sessions WHERE session_id = 0

(d) SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

This question was posed to me during an online exam.

Question is taken from SQL Audit in portion Monitoring and Auditing of SQL Server

Answer 1

Right answer is (d) SELECT latency FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

For explanation I would say: You can use latency data to determine how fast or slow the capture process is processing transactions.