Which three actions should you perform in sequence?

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.)

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:

Show Hint

Leave a Reply 2

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

Kevin Burgess

Kevin Burgess

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.

Reply

MMM

MMM

Recommend answer is correct.

Because it said ‘monitor deadlocks’. So I believe we need to use SSCM to achieve the goals.

Reply