|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, October 27, 2009 12:53 AM
Points: 9,
Visits: 26
|
|
Hi,
Is there any way of increasing memory available for SQL Server 2005? The
maximum I can set from SSMS is 2GB. My server has 8GB memory so I would like to set the memory limit to
3GB (or even more).
--
Eric.
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, March 18, 2010 10:25 PM
Points: 504,
Visits: 183
|
|
What is you Operating system Edition?
Is your system is 32 Bit or 64 Bit?
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: Yesterday @ 5:58 AM
Points: 687,
Visits: 1,074
|
|
Yeah...If it's 32 bit you will have to enable AWE option.
In 64 bit it's not necessary.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, October 27, 2009 12:53 AM
Points: 9,
Visits: 26
|
|
| My server is window server 2003 and 32 bit.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, October 27, 2009 12:53 AM
Points: 9,
Visits: 26
|
|
San-847017 (10/26/2009)
Yeah...If it's 32 bit you will have to enable AWE option.
In 64 bit it's not necessary.
I enabled AWE option but still couldn't increase server memory.
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, March 18, 2010 10:25 PM
Points: 504,
Visits: 183
|
|
I hope you have Window server 2003 Enterprise Edition
/PAE enabled in boot.ini?
Have you Enabled the Lock Pages in Memory Option (Windows)?
Please check the below URL for more details about Enabling AWE and Setting Min-Max Memory
http://technet.microsoft.com/en-us/library/ms190673.aspx
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 6:27 PM
Points: 817,
Visits: 12,627
|
|
Eric1208 (10/27/2009)
San-847017 (10/26/2009)
Yeah...If it's 32 bit you will have to enable AWE option.
In 64 bit it's not necessary.I enabled AWE option but still couldn't increase server memory.
When you say you cant set it more than 2gb. can you literally not set a value higher than 2gb and your getting an error message or are you reading the default value (its something stupidly high) as 2gb and think you cant make it more?
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Wednesday, March 17, 2010 7:29 AM
Points: 2,019,
Visits: 1,653
|
|
On a 32-bit server Task Manager does not know about memory above the 4GB line.
If you enable AWE you will have to look in the SQL Errorlog file for a message at startup time that says if AWE memory has been allocated. If you want to see some of the impact of using AWE ther aer performance counters that can tell you this.
It is worth searching some of the many threads on this subject for further advice.
Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2005, 2008, and 2008 R2. 24 February 2010: now over 9,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
|
|
|
|
