You need to check the disk, CPU, and memory utilization; information and still consider the network

You work as a SQL Server 2008 database administrator at ABC.com. One morning you have
received numerous complaints from the users at ABC.com that a database application is running
very sluggish. You need to check the disk, CPU, and memory utilization; information and still
consider the network.
What should you do?

You work as a SQL Server 2008 database administrator at ABC.com. One morning you have
received numerous complaints from the users at ABC.com that a database application is running
very sluggish. You need to check the disk, CPU, and memory utilization; information and still
consider the network.
What should you do?

A.
You should consider checking the event viewer.

B.
You should consider checking the appropriate dynamic management views (DMVs).

C.
You should consider checking the SQL performance monitor.

D.
You should consider running the SQL Server Profiler.

Explanation:



Leave a Reply 0

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