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

Review Questions

  1. You are the database administrator of a SQL Server 2005 instance. The server has recently been upgraded from 2GB to 4GB of RAM and from two processors to four processors because users were complaining about performance. Performance has not improved as much as management would have liked, and management has asked you to troubleshoot. The SQL Server 2005 instance has the following configuration:

    Configuration Option Configured Value
    affinity I/O mask 0
    affinity mask 0
    awe enabled 0
    cost threshold for parallelism 5
    lightweight pooling 0
    max degree of parallelism 0
    max server memory (MB) 2147483647
    max worker threads 2
    priority boost 1
    set working size 1
    user connections 0

    You need to ensure that performance ...

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