O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

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

Chapter 4. Configuring and Tuning Microsoft SQL Server

As with SQL Server 2000, SQL Server 2005 is designed to balance the workload dynamically and to self-tune configuration settings. For example, SQL Server can increase or decrease memory usage dynamically based on overall system memory requirements. SQL Server also manages memory efficiently, especially when it comes to queries and user connections—and memory is just one of dozens of areas in which the configuration is automatically adjusted.

Although the SQL Server self-tuning feature works well, there are times when you will need to configure ...

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