PrepAway - Latest Free Exam Questions & Answers

what should you do?

You are the administrator of your company network. And you’re in charge of a SQL Server 2008 infrastructure. The instance contains a database named RCC. Uses report that when executing reports, it makes response quite slowly. So you want to develop a monitoring strategy to monitor the performance. The strategy captures and stores the data such as Counters for disk, CPU, and memory, blocking and deadlock information, and executed Transact-SQL statements and query activity. When running the monitoring process, you must use as little administrative effort as possible. So what should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
You should use the data collector.

B.
You should use the dynamic management views.

C.
You should use the client-side profiler trace.

D.
You should use the System Monitor counter log trace.


Leave a Reply