Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Configure Memory for More Than 2 GB in SQL Server

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2002-04-08 : 11:42:31
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.

Article Link.


- Advertisement -