what should you do to capture the deadlock information to the SQL Server error log?

You are the administrator of your company network. You maintain a SQL Server 2008 instance which contains a database named Taskgo. Now deadlock problems always occur on the Taskgo database. So what should you do to capture the deadlock information to the SQL Server error log?

You are the administrator of your company network. You maintain a SQL Server 2008 instance which contains a database named Taskgo. Now deadlock problems always occur on the Taskgo database. So what should you do to capture the deadlock information to the SQL Server error log?

A.
You should enable Server Auditing

B.
You should configure the data collector to capture the deadlock graphs.

C.
You should configure a SQL Profiler trace to capture the deadlock graphs.

D.
You should set the appropriate trace flags as a startup parameter and restart the SQL Server instance.



Leave a Reply 0

Your email address will not be published. Required fields are marked *