PrepAway - Latest Free Exam Questions & Answers

You need 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.

image.39.png

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