Answers to Assessment Test
- 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.”
- C. Although the operating system seems to have plenty of available memory, as indicated by the ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.