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

TestKing.com uses SQL 


TestKing.com uses SQL Server 2005. Users report with increasing frequency that they receive deadlock error messages in an order processing application.   You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do?()

  • ATrace the Lock:Timeout event by using SQL Server Profiler.
  • BObserve the SQLServer:Locks - Number of Deadlocks/sec counter by using System Monitor.
  • CTrace the Lock:Deadlock event by using SQL Server Profiler.
  • DTrace the Lock:Deadlock Chain event by using SQL Server Profiler.
参考答案
参考解析:
分类:MCTS(70-431)题库
相关推荐

1、TestKing.com has two S

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A user in TestKing.com&ensp...

2、你是 TestKing.com 的一位安全管理人。所有

你是 TestKing.com 的一位安全管理人。所有的域控制者运行Windows Server 2003。所有的客户计算机运行Windows Server 2003。TestKing在(柏林、...

3、TestKing.com has two S

TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Both servers take part&ensp...

4、TestKing.com Web site 

TestKing.com Web site includes a page that customers use to send feedback about the company&ens...

5、TestKing.com uses a SQ

TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg Insert...

6、TestKing.com has multiple&e

TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 20...