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.

28 Chapter 1 • New Features in SQL Server 2008