DRAG DROP
You administer a Microsoft SQL Server 2012 database.
Your database is experiencing deadlock issues.
You need to be able to monitor deadlocks.
Which three actions should you perform in sequence? (To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)
Answer: 
Explanation:
Is this really a question? Would I really want to disrupt an instance just to trace deadlock issues? Is it really a parameter I want to start automatically with the instance?
The correct answer would be DBCC TRACEON(1222, -1) without using the SSCM.
0
0
Recommend answer is correct.
Because it said ‘monitor deadlocks’. So I believe we need to use SSCM to achieve the goals.
0
0