Configure Memory for More Than 2 GB in SQL Server

By Bill Graziano on 08 April 2002 | 0 Comments | Tags: Memory Tuning

This article describes how to configure SQL Server to use more than 2 GB of physical memory. Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 dynamically acquire and free memory as needed. When you run multiple instances of SQL Server on a computer, each instance dynamically acquires and frees memory to adjust for changes in the workload of the instance. This is a Microsoft Knowledge Base article. Follow the link to Configure Memory for More Than 2 GB in SQL Server...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 8,123 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

What Query Plans are in SQL Server's Memory? (25 July 2007)

What Data is in SQL Server's Memory? (23 July 2007)

Inside SQL Server 2000's Memory Management Facilities (29 January 2004)

HOW TO: Configure Memory for More Than 2 GB in SQL Server (Q274750) (10 June 2002)