PrepAway - Latest Free Exam Questions & Answers

You need to capture the deadlock information to the SQL Server error log

You configure a SQL Server 2008 instance that contains a database named Customers. The
Customers database experiences deadlock problems.
You need to capture the deadlock information to the SQL Server error log.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Enable file system auditing.

B.
Enable the Windows Event Collector service.

C.
Configure trace flags and then restart the SQL Server instance.

D.
Configure a Data Collector Set and then restart the SQL Server instance.


Leave a Reply