You manage an on-premises Microsoft SQL server that has a database named DB1.

An application named App1 retrieves customer information for DB1.

Users report that App1 takes an unacceptably long time to retrieve customer records.

You need to find queries that take longer than 400 ms to run.

Which statement should you execute?

A.



B.



C.



D.



Explanation:

Total_worker_time: Total amount of CPU time, reported in microseconds (but only accurate to milliseconds), that was consumed by executions of this plan since it was compiled.

Incorrect Answers:

A: Qs.max_worker_time: Maximum CPU time, reported in microseconds (but only accurate to milliseconds), that this plan has ever consumed during a single execution.

References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-stats-transact-sql