O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Answers to Assessment Test

  1. A, F. Changing the max affinity mask configuration option to 0 will enable the SQL Server 2005 instance to utilize all eight processors. Changing the max server memory (MB) configuration option to 0 will enable the SQL Server 2005 instance to utilize as much memory as it requires. You don't need to configure the awe enabled configuration option on a 64-bit server. Changing the affinity I/O mask, max degree of parallelism, or priority boost configuration option should have a minimal effect on SQL Server 2005's performance. For more information, see Chapter 1, “Optimizing the Performance of Databases and Database Servers.”
  2. C. Although the operating system seems to have plenty of available memory, as indicated by the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required