Awe memory setting for sql 2005 on win 2003

[timscronin]

I have been given a box setup by a consultant. It is a new Dell with 16 gig of memory running on win2003 server with sql 2005 Enterprise Edition. With 2 users it is running slow. I checked the memory setting and notice the awe setting is not checked? Should this be checked. Task manager perfmon shows only 3 gig being utilized

 

[ptheriault]

Tim, you should see the post named Memory Question by me. Catadmin answered that question there. Basically if you OS is 64 bit you don't need it. If your OS is 32 bit you do.

 

[Jamfool]

Well if you using more than 4gb on a 32bit system:

http://msdn2.microsoft.com/en-us/library/ms190673.aspx

 

[timscronin]

trying to use 15 gig on 32 bit system

 

[ptheriault]

Then you will need to enable AWE.

sp_configure 'show advanced options', 1
RECONFIGURE
GO

sp_configure 'awe enabled', 1
RECONFIGURE
GO

 

[ptheriault]

I forgot to mention.
I think you need to add the /PAE switch in the boot.ini file.