Microsoft
70-450 · Question #121
You configure a SQL Server 2008 instance that contains a database named Customers. The Customers database experiences deadlock problems. You need to capture the deadlock information to the SQL…
The correct answer is C. Configure trace flags and then restart the SQL Server instance. See the full explanation below for the reasoning.
Question
You configure a SQL Server 2008 instance that contains a database named Customers. The Customers database experiences deadlock problems. You need to capture the deadlock information to the SQL Server error log. What should you do?
Options
- AEnable file system auditing.
- BEnable the Windows Event Collector service.
- CConfigure trace flags and then restart the SQL Server instance.
- DConfigure a Data Collector Set and then restart the SQL Server instance.
How the community answered
(32 responses)- B6% (2)
- C84% (27)
- D9% (3)
Community Discussion
No community discussion yet for this question.