You administer a SQL Server 2008 infrastructure. The instance contains a database
required for the day-to-day business of your company. Users experience slow response
time when they execute reports. You plan to design a performance monitoring strategy that
captures and stores the following data: Executed Transact-SQL statements and query
activity. Blocking and deadlock information. Counters for disk, CPU, and memory. You
need to implement the monitoring process by using the minimum amount of administrative
effort. What should you do?
A.
Use the data collector.
B.
Use the client-side profiler trace.
C.
Use the dynamic management views.
D.
Use the System Monitor counter log trace.