Exam 70-764 topic 1 question 288 discussion

Actual exam question from Microsoft's 70-764

Question #: 288
Topic #: 1

You have an SQL Server 2014 server named SQL1. You are designing a performance monitoring solution. You need to monitor the following events on SQL1:
✑ A deadlock graph
✑ Missing column statistics

CPU performance statistics -

✑ A batch of completed Transact-SQL statements
Which two tools should you use? Each correct answer presents a complete solution.

A. dynamic management views
B. Database Engine Tuning Advisor
C. SQL Server Profiler
D. Activity Monitor
E. Data Profile Viewer

Show Suggested Answer

Suggested Answer: BC 🗳️
B: Database Engine Tuning Advisor examines how queries are processed in the databases you specify.
When you run a Profiler Trace and feed it to the Database Engine Tuning Advisor, it also looks for missing column statistics, and it can automatically create them for you. C: Use SQL Server Profiler to identify the cause of a deadlock. A deadlock occurs when there is a cyclic dependency between two or more threads, or processes, for some set of resources within SQL Server. Using SQL Server Profiler, you can create a trace that records, replays, and displays deadlock events for analysis.
References: https://msdn.microsoft.com/en-us/library/ms188246.aspx

by TheSwedishGuy at Feb. 4, 2020, 12:08 p.m.

Comments

Submit Cancel

Cococo

4 years, 7 months ago

Tuning Advisor is for tuning, not for the Monitoring... Instead, we should use DMV as Microsoft recommends - https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs

upvoted 1 times

dxico

4 years, 5 months ago

you can feed the DETA with data collected by profiler, so I agree with TheSwedishGuy

upvoted 1 times

...

TheSwedishGuy

5 years, 4 months ago

✑ A deadlock graph = SQL Server Profiler ✑ Missing column statistics = Database Engine Tuning Advisor

upvoted 4 times

...