YOU HAVE A SERVER THAT SUPPORTS HOT ADD MEMORY. PERFORMANCE IS SLU...

19. You have a server that supports Hot Add Memory. Performance is sluggish,

and you believe adding more memory will help. 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 memory to the server.

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

Hot Add Memory, which makes Answer C incorrect. Answers A and B are

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

not solve the problem.