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

Assessment Test

  1. 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

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