PrepAway - Latest Free Exam Questions & Answers

What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. Users report that all client applications that connect to AIOTestKing A are responding slowly. You discover that AIOTestKing As CPU and memory utilization is low and that disk activity is low. You need to identify the cause of the performance problem.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use System Monitor to examine AIOTestKing As cache hit ratio.

B.
Examine the sys.dm_db_index_physical_stats dynamic management function (DMF).

C.
Use Task Manager to examine utilization of AIOTestKing As network adapter.

D.
Examine the sys.dm_db_partition_stats dynamic management view (DMV).

Explanation:
The Task Manager will show you the current status of all network adapters and their workload. If the Server experiences a lot of network activity that could cause the applications to respond slowly.


Leave a Reply