which searches use the most resources. What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 instance. The database enables the Domain.com users to operate both ad hoc and
predefined searches. There is however a suspicion that some searches will cost too much of the
available resources and you need to make sure which searches use the most resources.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 instance. The database enables the Domain.com users to operate both ad hoc and
predefined searches. There is however a suspicion that some searches will cost too much of the
available resources and you need to make sure which searches use the most resources.

What should you do?

A.
You should consider using the DBCC INPUTBUFFER requirements.

B.
You should consider using the sqldiag function.

C.
You should consider using the SHOWPLAN session selection.

D.
You should consider using the sys.dm_exec_query_stats dynamic management view (DMV).



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Charis

Charis

Hi to every body, it’s my first visit of this weblog; this
web site includes amazing and really excellent information designed for visitors.