Microsoft
70-432 · Question #54
You are the administrator of a SQL Server 2008 instance with a database named Dworks. You get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to…
The correct answer is B. First you should set the appropriate trace flags as a startup parameter. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with a database named Dworks. You get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?
Options
- AFor the AdventureWorks database, enable Server Auditing
- BFirst you should set the appropriate trace flags as a startup parameter,
- CYou should configure the data collector and make it capture the deadlock graphs
- DYou should configure a SQL Profiler trace, and make it capture the deadlock graphs
How the community answered
(41 responses)- A7% (3)
- B85% (35)
- C5% (2)
- D2% (1)
Community Discussion
No community discussion yet for this question.