You work as a database administrator at ABC.com. ABC.com is making use of SQL Server 2008
R2.
ABC.com has a server running an instance of SQL Server 2008 R2, which hosts a database
named ABC_Clients.
When ABC_Clients encounter numerous deadlock issues, you configure the instance’s startup
parameters with the necessary trace flags and reboot the instance.
Which of the following is TRUE regarding this configuration?
A.
It allows for the capturing of deadlock data in the SQL Server error log.
B.
It allows for the capturing of deadlock data in the SQL Server event log.
C.
It allows for the capturing of deadlock data in the SQL Server trace log.
D.
It allows for the capturing of deadlock data in the SQL Server transaction log.
Explanation: