Assessment Test
-
You are the database administrator of a dedicated SQL Server 2005 Enterprise Edition (x64) instance. The server has recently been upgraded from four processors to eight processors. Memory was also upgraded from 8GB to 16GB of memory. Natasha, a junior DBA, has reconfigured the SQL Server 2005 instance accordingly. The performance has not improved after the hardware upgrade as much as management would have expected. You have been asked to troubleshoot the SQL Server 2005 instance. The SQL Server 2005 instance has the following configuration:
Configuration Option Configured Value affinity I/O mask 0 affinity mask 4 awe enabled 0 cost threshold for parallelism 5 lightweight pooling 0 max degree of parallelism
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
