You need to monitor the following events on SQL1: A dea…

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.

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

Explanation:
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.
Analyze Deadlocks with SQL Server Profiler
https://msdn.microsoft.com/en-us/library/ms188246.aspx
Mastering SQL Server Profiler, page 245



Leave a Reply 0

Your email address will not be published. Required fields are marked *