试题详情
- 单项选择题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？（）
A、Use the DBCC INPUTBUFFER command.
B、Use the sys.dm_exec_query_stats dynamic management view （DMV）.
C、Use the sqldiag utility.
D、Use the SHOWPLAN session option.
- B
关注下方微信公众号，在线模考后查看
热门试题