Standard Edition with /3GB switch

Question

Standard Edition with /3GB switch

John Burns-302570

Newbie

Points: 9
More actions
December 4, 2007 at 9:24 am

#71194

all,
Can SQL standard see/use above 2G when the 3/gb
switch is in the boot.ini.
Os = Winserver2003 standard edtion
thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Minaz Amin SSChampion Points: 11052 More actions · Answer 1

On Windows, by default, the lower 2 GB are reserved for user-mode programs and the upper 2 GB are reserved for kernel-mode programs. Booting with the /3GB parameter decreases the amount of kernel virtual address space on the system by 1 GB.

These are the links will help you more to understand !!!

http://support.microsoft.com/kb/274750

http://msdn2.microsoft.com/en-us/library/aa175282(SQL.80).aspx

"More Green More Oxygen !! Plant a tree today"

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 2

Hi,

You cannot use it with SQL Server 2000 standard edition and Windows 2003 standard edition.

Check the following links:

How to configure SQL Server to use more than 2 GB of physical memory

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech%5B/url%5D

http://support.microsoft.com/default.aspx?scid=kb;en-us;291988

http://www.sql-server-performance.com/tips/awe_memory_p1.aspx

http://sql-server-performance.com/Community/forums/t/14372.aspx

in the last article yo will find the following

I called Microsoft for clarification since we are crunched for time.

The call didn't start out well since the tech said she was unfamiliar with using the 3GB switch

with SQL Server 2000 Enterprise Edition, but said it is supported with SQL 2000 Standard Edition.

I said she had it reversed and we spent about 10 minutes reviewing articles indicating how Standard Edition

would not go above 2GB. Once we made it past that point it was explained to me that most applications run

in user mode, not kernel mode, so the chances of 1GB of the kernel being used on my server were between

slim and none. The only applications running on my server are SQL Server 2000 EE, Outlook 2003,

Microsoft Operations Manager, Cisco Security Agent and Doubletake, a file replication package for DR.

I was told when the 3GB switch is used the OS allocates 3GB to each application running on the server.

This means SQL Server can use up to 3GB, Outlook 2003 up to 3GB, MOM... etc... If 3GB of physical memory has

already been used, it will go to disk for the additional memory. My only concern is how to prevent Outlook,

MOM, CSA and Doubletake from getting out of control and requesting 3GB of memory.

The odds of this happening is slim, but it sounds like a possibility.

Regards,

Ahmed

Minaz Amin SSChampion Points: 11052 More actions · Answer 3

Yes and I have only explained how /3gb effect the address space.

"More Green More Oxygen !! Plant a tree today"

SQL_ABD SSCertifiable Points: 5832 More actions · Answer 4

Hi Minaz,

Yes I understood I just want share information I have

Thanks