You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. Domain.com also contains an
application that makes use of the SELECT command that triggers the population of multiple
tables. This application also makes use of CK_DB1. One morning you have received several
complaints from the users that the application is performing very sluggish. You now need to
control the status of the sample without affecting the application performance.

What should you do?

A.
You should consider using the Process Monitor Tool.

B.
You should consider using the Web Service.

C.
You should consider using the SQL Server Resource Governor.

D.
You should consider using the Dynamic Management Views: