PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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