Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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

By Bill Graziano on 10 June 2002 | 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.

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

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

I have a sql query which returns a sum of total amount by user and I am trying to add another column which uses the total and multiply it by a number (20h)

Troubleshooting Deadlocks in SQL Server (10d)

Last Login date and time (11d)

Negative effects of High VLF counts (11d)

Need to return a value that indicates that a record has been added, but not when a record is modified (12d)

Indexex on low cardinality fields (12d)

Error in stored procedure (13d)

Spam post flagging (13d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources