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

You are a database&#


You are a database administrator for your company. The company’s financial forecasting application uses a SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You suspect that some queries consume an excessive amount of server resources. You need to identify which queries consume the most resources. You want to achieve this goal as quickly as possible. What should you do?()

  • AUse the DBCC INPUTBUFFER command.
  • BUse the sys.dm_exec_query_stats dynamic management view (DMV).
  • CUse the sqldiag utility.
  • DUse the SHOWPLAN session option.
参考答案
参考解析:
分类:MCITP(70-444)题库
相关推荐

1、若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值

若a=5,b=3,c=4,逻辑表达式!(a+b)&;&;!c的值为()A0B-1C1D2

2、现有int a,*b;,b=&a;,则下列运算错误的是

现有int a,*b;,b=&a;,则下列运算错误的是A*&aB&*aC*&bD&*b

3、You are a database&#

You are a database administrator of two SQL Server 2005 computers named SQL1 and ...

4、You are a database&#

You are a database administrator for your company. The company uses a SQL Server ...

5、You are a database&#

You are a database administrator for your company. The company uses a SQL Server ...

6、You are a database&#

You are a database administrator for your company. A database on one of the compa...