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
AdventureWorks.

The AdventureWorks 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 Server Auditing for the AdventureWorks database.

B.
Configure the data collector to capture the deadlock graphs.

C.
Configure a SQL Profiler trace to capture the deadlock graphs.

D.
Set the appropriate trace flags as a startup parameter and restart the SQL Server
instance.


Leave a Reply