可学答题网 > 问答 > 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)题库