Using SQL Server with Large Amounts of Memory

Rating:

(0)

Brian Moran

SQL Server Magazine

InstantDoc ID #45156

What's the best way to configure SQL Server to handle large amounts of memory, and how do I know when to use the /3GB switch?

Many customers are still confused about how to configure SQL Server when large amounts of memory are installed on the machine. I don't have the space to fully explore this topic here; however, I'll try to clear up some basic misunderstandings and point out a best practice for determining when to use the /3GB switch. I also strongly encourage you to read ...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Technet Library specifically states "Important: The /3GB switch should not be used on Windows 2000 Server because it is unsupported and can cause application or operating system crashes."

Definitely would be helpful if the article indicated this... These tips only apply for Win2k Datacenter or Advanced, pretty important exceptions.

Bruce8/20/2007 3:11:43 PM

There could be more information in chart format using 2 GB, 4 GB, 12 GB, 16 GB, and 32 GB configurations when compared to switches showing /PAE and /3GB scenarios. Also, it would be nice to see in this chart SQL 2000 and SQL 2005 running on Standard/AdvancedDatacenter Server 2000 with the configurations above. To be up to date, it would be nice to see this chart on the same for 32 and 64 bit servers running WIN 2003 ... wow! Too many situations, too little information. But article above is still a big help. Thanks Tom.

JAMES1/21/2007 6:13:03 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

SSIS Performance Tuning, Connecting to Heterogeneous Sources, and Complex Transformations
A White Papers by expressor software

The Essential Guide to Mission-Critical Microsoft SQL Server
A Essential Guides by EMC

A Business Case for Lowering Enterprise Total Cost of Ownership - Microsoft SQL Server for SAP on HP Integrity Servers
A White Papers by Hewlett-Packard

Tuna Helper - Tuning SQL Statements: A Proven Process for SQL Server Environments
A White Papers by Confio

Paid Case Study of Sr. IT Professionals in $1B+ companies who migrated from Sybase/ Oracle to SQL Server 2008

Pique Solutions (www.piquesolutions.com), a premier consulting firm working with Fortune 500 technology vendors, is developing a video Case Study on b...