You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. However, recently CK_Prod has
produced deadlock problems. You have received instructions from management to get the
deadlocks on the SQL Server error log.
What should you do? (Choose TWO)
A.
You should consider using the SQL Profiler trace.
B.
You should consider enabling the Server Auditing for CK_Prod.
C.
You should consider setting up the trace flags and reboot the SQL Server instance.
D.
You should consider using the Transactions Log.