Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Configure Memory for More Than 2 GB in SQL Server

By Bill Graziano on 8 April 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. This is a Microsoft Knowledge Base article.

Link: Configure Memory for More Than 2 GB in SQL Server

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)

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

Other Recent Forum Posts

Query performance Call Center data (20h)

Looking for on Premises tool to read data from SQL logs and populate data warehouse (1d)

Possible SQL 2014 to 2016 Issue - Some Application Functions Slow/Failing (1d)

Working with multiple WHERE statements (1d)

Create a new field value that shows a difference in value from 2 fields (3d)

Hierarchy wise Sales Targets (3d)

Get the MaxDate in results (5d)

Switch Statement within a SSRS SQL Expression (6d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources