You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
After receiving a complaint from a ABC.com user regarding the sluggish execution of the
applications on the server, you decide not to make use of the table scans to obtain additional data
as a result of the poor execution.
You have to gather the necessary data in another way.
Which of the following actions should you take?
A.
You should consider making use of the SQL Server:Memory Manager Object utility via the
Windows System Monitor.
B.
You should consider making use of the SQLServer:Disk Manager utility via the Windows
System Monitor.
C.
You should consider making use of the SQL Server:Database Mirroring Object utility via the
Windows System Monitor.
D.
You should consider making use of the SQLServer:Access Methods utility via the Windows
System Monitor.
Explanation: