Suggested Answer:A🗳️
sys.dm_exec_query_optimizer_info teturns detailed statistics about the operation of the SQL Server query optimizer. You can use this view when tuning a workload to identify query optimization problems or improvements. For example, you can use the total number of optimizations, the elapsed time value, and the final cost value to compare the query optimizations of the current workload and any changes observed during the tuning process. References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-optimizer-info-transact-sql
I think none of them.
Optimizer info shows cumulative info since the last restart.
plan_attributes shows only for specific plan handle
procedure_stats show procedures stats (not all queries) and have no index info
requests also has no index info
sys.dm_exec_query_stats or sys.dm_exec_plan_attributes will help you find the long running transactions. Sources: Brent Ozar site
upvoted 2 times
...
This section is not available anymore. Please use the main Exam Page.70-464 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Zikato
4 years, 4 months agoIuliana16
4 years, 10 months agosanketh
4 years, 11 months ago