YOU HAVE A SERVER THAT SUPPORTS HOT ADD CPU. THE CURRENT CPU UTILI...

17. You have a server that supports Hot Add CPU. The current CPU utilization is

95 to 100 percent most of the time. The server is mission-critical and cannot be

shut down. SQL Server 2008 Standard Edition is installed. What should you do?

A. Use the Hot Add CPU feature to add another CPU

B. Use the Hot Add CPU feature to add two CPUs

C. Add more memory to the server

D. Schedule an outage and add another CPU to the server

The correct answer is D. SQL Server 2008 Standard Edition does not

support Hot Add CPU, which makes Answers A and B incorrect. Answer C

is incorrect—the issue is CPU, so adding more memory will in all likelihood

not solve the problem.