You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_DB1.
ABC.com also contains an application that makes use of the SELECT command to initiate the
process of populating various tables simultaneously. This application also makes use of
ABC_DB1.
When you receive several complaints from ABC.com’s users that the application is performing
very sluggish, you decide to keep an eye on the status of the SQL Server 2008 R2 instance. You
want to make sure that application performance is not influenced by your actions.
Which of the following actions should you take?
A.
You should consider making use of the Process Monitor Tool.
B.
You should consider making use of the Web Service.
C.
You should consider making use of the event viewer.
D.
You should consider making use of the Dynamic Management Views tool.
Explanation: