You use Microsoft SQL Server Profile to evaluate a query named Query1. The Profiler report indicates the
following issues:
– At each level of the query plan, a low total number of rows are processed.
– The query uses many operations. This results in a high overall cost for the query.
You need to identify the information that will be useful for the optimizer.
What should you do?
A.
Start a SQL Server Profiler trace for the event class Auto Stats in the Performance event category.
B.
Create one Extended Events session with the sqlserver.missing_column_statistics event added.
C.
Start a SQL Server Profiler trace for the event class Soft Warnings in the Errors and Warnings event
category.
D.
Create one Extended Events session with the sqlserver.missing_join_predicate event added.
Explanation:
The Missing Join Predicate event class indicates that a query is being executed that has no join predicate. This
could result in a long-running query.
I recently pass the exam.
The Create one Extended Events session with the sqlserver.missing_join_predicate event added option is not there.
this answer is not right.
12
0
B is Correct.
A is wrong: The Auto Stats event class indicates that an automatic updating of index and column statistics has occurred. Auto Stats also fires when statistics are being loaded for use by the optimizer.
C is wrong: Soft Warnings are not useful for the optimizer
D is wrong: The Missing Join Predicate event class indicates that a query is being executed that has no join predicate. Not useful for the optimizer
5
0