You configure a SQL Server 2008 instance that contains a database named
AdventureWorks.
The AdventureWorks database experiences deadlock problems.
You need to capture the deadlock information to the SQL Server error log.
What should you do?
A.
Enable Server Auditing for the AdventureWorks database.
B.
Configure the data collector to capture the deadlock graphs.
C.
Configure a SQL Profiler trace to capture the deadlock graphs.
D.
Set the appropriate trace flags as a startup parameter and restart the SQL Server
instance.