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

By Bill Graziano on 10 June 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. Follow the link to HOW TO: Configure Memory for More Than 2 GB in SQL Server (Q274750)...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

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)

Configure Memory for More Than 2 GB in SQL Server (8 April 2002)

Other Recent Forum Posts

SQL Error 7320.......Using linked servers (9 Replies)

Exporting from old table to new tables (1 Reply)

Deleting Oldest Date (3 Replies)

Database with no FK (2 Replies)

From Litespeed task to Networker (2 Replies)

SQL SERVER 2014 & VS2013 instance issues (3 Replies)

XML Bulk load (0 Replies)

Databases sync for secondary server (1 Reply)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -