Question

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

I had been asked this question during an interview.

This intriguing question comes from SQL Audit in portion Monitoring and Auditing of SQL Server

Answer 1

The correct option is (b) SELECT command_count/duration AS [Throughput] FROM sys.dm_cdc_log_scan_sessions WHERE session_id = 0

Best explanation: To determine the throughput of a session, divide the value in the command_count column by the value in the duration column.