You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1. You need to monitor Pool1. The solution must ensure that you capture the start and end times…

The SqlRequests log category tracks individual SQL statements at submission time but is not specifically focused on capturing the full start-to-end execution timestamps of completed queries in the way ExecRequests is.

The RequestSteps log records the individual distributed plan steps that make up a query's execution graph, not the overall start and end times of the query as a whole.

The DmsWorkers log captures activity from Data Movement Service worker threads involved in distributed operations and does not contain query-level execution start and end timestamps.

The ExecRequests log captures every SQL request submitted to the dedicated SQL pool along with its start time, end time, elapsed time, and completion status. Because it records the complete lifecycle timestamps for each finished query, it is the appropriate diagnostic setting when you need to audit or monitor how long each query ran from start to finish in Pool1.