Explanation:tran_id denotes ID of the transaction. 9. Which of the following query returns the average throughput for the most recent sessions ?
A. SELECT command_count*duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
B. SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0
C. SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sesss WHERE session_id = 0
D. None of the mentioned
Answer:A
Explanation:tran_id denotes ID of the transaction. 9. Which of the following query returns the average throughput for the most recent sessions ?
A. SELECT command_count*duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0 B. SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0 C. SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sesss WHERE session_id = 0 D. None of the mentioned
Explanation:To determine the throughput of a session, divide the value in the command_count column by the value in the duration column. 10.sys.fn_cdc_map_time_to_lsn returns ________ value from the start_lsn column in the cdc.lsn_time_mapping system table for the specified time.