January 20, 2009 at 1:29 am
Hi,
i've Windows Server 2003 32BIT ENT edition with 8GB MEM.
can i force SQL Server 2005 STD 32BIT to see(work) with more the 2.8GB that it's use now?(maybe AWE?)
THX
January 20, 2009 at 1:48 am
SQL Server 2005 standard edition supports working with awe, so you can enable your server to work with more then 2GB. BOL has some articles on how to configure SQL Server and the OS when you want to work with awe. I recommend that you’ll read the articles Using awe (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/110f75a0-78a4-41bd-9c1f-cc4c8b458947.htm) and Enabling AWE Memory for SQL Server
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c44df11e-2b75-424c-bc14-56646169a56f.htm) before configuring the use of awe
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 20, 2009 at 1:51 am
You can put almost all RAM that you have but put /USERVA and /PAE in boot.ini ,enable AWE and put 'max server memory' and 'min server memory' with sp_configure at the mssql level at your desired level.
January 20, 2009 at 2:25 am
thx for your answer.
I've read in the BOL and didn't see any mention about the /USERVA.
what is it ?
THX
January 20, 2009 at 2:37 am
it's the same setting like /3GB ,but it's for windows 2003 servers .
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply