O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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 18. Microsoft SQL Server 2005 Memory Configuration

Internal memory management for Microsoft SQL Server 2005 has changed in many ways since SQL Server 2000. Configuring memory on the system has remained very similar, though. This chapter covers the configuration topics. Configuring memory effectively can greatly improve database performance, so it is important to understand the options database admistrators have in this area. This chapter focuses on the basics of buffer cache management and memory configuration settings and options in SQL Server 2005 to allow you to make informed decisions about SQL Server memory configuration for performance. This chapter explains several important SQL Server ...

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