Exam 70-765 topic 3 question 100 discussion

Actual exam question from Microsoft's 70-765

Question #: 100
Topic #: 3

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.

Show Suggested Answer

Suggested Answer: B
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

by MelKr at May 18, 2020, 3:03 p.m.

Comments

Submit Cancel

MelKr

Highly Voted 5 years, 2 months ago

A ist correct. We need to find queries which run longer than 400 ms in a single execution, not in total. As the runtime does not need to be 100% CPU "elapsed_time" needs to be queried.

upvoted 9 times

...