|
|
|
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.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, November 13, 2009 5:27 AM
Points: 169,
Visits: 94
|
|
What is you Operating system Edition?
Is your system is 32 Bit or 64 Bit?
|
|
|
|
|
Mr or Mrs. 500
Group: General Forum Members
Last Login: Friday, November 13, 2009 1:40 AM
Points: 518,
Visits: 883
|
|
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.
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, November 13, 2009 5:27 AM
Points: 169,
Visits: 94
|
|
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
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: Yesterday @ 2:03 PM
Points: 727,
Visits: 11,670
|
|
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?
|
|
|
|
|
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 9:31 AM
Points: 1,911,
Visits: 1,502
|
|
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 configuration of SQL Server 2005 and 2008.
1 October 2009: now over 7,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Fun: You can lead a user to data, but you can't make them think (Anon).
|
|
|
|
