SQLTeam.com Logo

Return to HOW TO: Configure Memory for More Than 2 GB in SQL Server (Q274750)

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

Written by Bill Graziano on 10 June 2002

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.