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.
Answer:B
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.