You are the administrator of a Microsoft Windows NT Server 4.0 computer. The server is the PDC in your domain and also runs SQL Server 2000. The server has four processors and 1 GB of RAM.Your network consists of 500 client computers that are running Microsoft Windows Millennium Edition. Users report that when they log on in the morning their computers respond slowly and occasionally return error messages.You use System Monitor to monitor processor performance and RAM utilization. You discover that the % Total Time and % User Time counters average 90 percent and the % Privileged Time counter averages 20 percent. The Available Mbytes counter averages 800 MB. You need to improve server performance for user logons. What should you do?

by

A) Increase the physical RAM on the computer to 2 GB.

B) Increase the virtual RAM on the computer to 4 GB.

C) Configure SQL Server to use only processors 0, 1, and 2.

D) Configure SQL Server to use only processors 1, 2, and 3.

View Answer
Option – D.

Similar Questions