试题详情
- 单项选择题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?（）
A、For the AdventureWorks database, enable Server Auditing
B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance
C、You should configure the data collector and make it capture the deadlock graphs
D、You should configure a SQL Profiler trace, and make it capture the deadlock graphs
- B
关注下方微信公众号，在线模考后查看
热门试题
- You are creating a
- 你是 TestKing.co
- You copy a Web site
- You are th
- You create a large,
- All servers&en
- 你是TestKing网站的电脑管理员。M
- You have
- You are creating an
- You are d
- Certkiller.COM有一个Act
- Your portable&
- 您有一个Active Dir
- Your company&e
- You create a server
- Bruno有一个笔记本电脑，包含两个硬盘
- 你是冒险工作室的电脑管理员，你在25台新
- You designQ
- Your organization i
- You are a