DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales
management application.
Occasionally, users of the application report that they receive a deadlock error. You plan to
troubleshoot this error.
You need to ensure that the instance is configured to capture troubleshooting information
that will create an XML document detailing the deadlock condition.
Which two 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:

Note:
First set the appropriate flag. Then restart the service.
To view deadlock information, the Database Engine provides monitoring tools in the form of
two trace flags, and the deadlock graph event in SQL Server Profiler.
Trace Flag 1204 and Trace Flag 1222
When deadlocks occur, trace flag 1204 and trace flag 1222 return information that is
captured in the SQL Server error log. Trace flag 1204 reports deadlock information formatted
by each node involved in the deadlock. Trace flag 1222 formats deadlock information, first
by processes and then by resources. It is possible to enable both trace flags to obtain two
representations of the same deadlock event.