You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?()
- AFor the AdventureWorks database, enable Server Auditing
- BFirst you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance
- CYou should configure the data collector and make it capture the deadlock graphs
- DYou should configure a SQL Profiler trace, and make it capture the deadlock graph