可学答题网 > 问答 > MCTS(70-432)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You work in a 


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
参考答案
参考解析:
分类:MCTS(70-432)题库
相关推荐

1、You work in a 

You work in a company which is named Wiikigo Corp. The company uses SQL Server&#8...

2、You work in a 

You work in a data warehouse environment that involves the execution of complex queries...

3、You work in a 

You work in a company which uses SQL Server 2008. You are the administrator of&#8...

4、You work in a 

You work in a company which is named Wiikigo Corp. The company uses SQL Server&#8...

5、You work in a 

You work in a company which uses SQL Server 2008. You are the administrator of&#8...

6、You work in a 

You work in a company which uses SQL Server 2008. You are the administrator of&#8...