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?

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?

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 0

Your email address will not be published. Required fields are marked *