PrepAway - Latest Free Exam Questions & Answers

What should you do to improve database performance?

Your network contains a database server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).
Server1 has the following hardware configurations:
. A single processor that supports hyper-threading

·Dual processor motherboard

·Two hard disks

·2 GB of RAM

The first disk contains all the files for the operating system and applications. The second disk is empty.
Hyper-threading is disabled in the BIOS.
Users report a slow response when they query the database on Server1.
You monitor Server1 for one day and receive the performance statistics shown in the following table.
You need to improve database performance.


What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Upgrade the RAM to 4 GB.

B.
Install a second processor.

C.
Enable hyper-threading in the BIOS.

D.
Move the database to the second disk.


Leave a Reply