Maximum Memory Windows Server 2003 32 bit?
-
I have gotten complaints from a group of external developers that one of the machines they are working on only has 4 GB of memory. .
What is the maximum memory for a Windows Server 2003 Standard Edition 32 bit running SQL Server 2005?
I understand that it is limited based on Operating system.
It has been a while since I worked with AWE any information pertaining to that subject as it relates to this situation would be appreciated.
For better, quicker answers on T-SQL questions, click on the following...
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/ -
for the operating system, i *think* it's 192 gig, based on this page:
http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#memory_limits
for SQL 2005, a lot of it depends on the AWE and PAE settings, since it's probably a 32 bit installation, right?
if those settings are not set, i think it's 2 or 3 gig, otherwise with the settings set correctly it's the operating system maximums.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
After reading a number of articles
http://msdn.microsoft.com/en-us/library/aa366796.aspx
http://msdn.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003
It would seem that Server 2003 Standard x86 supports by default 4GB which we all knew, with PAE it can address up to 64GB or 128GB depending on the processor.
After that SQL can then see what ever the OS maximum.
Personally if you have 32GB of memory and they are complaining, I would seriously look at what they are doing
-
I could do an in Place Upgrade to the OS to Enterprise Edition.
Has anyone tried that and what was the outcome>
For better, quicker answers on T-SQL questions, click on the following...
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/ -
I typed 32 GB of memory, it is 4 GB of memory on a 32 bit OS.:w00t:
Thanks for all of the information.
For better, quicker answers on T-SQL questions, click on the following...
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/ -
Welsh Corgi (7/17/2012)
I could do an in Place Upgrade to the OS to Enterprise Edition.Has anyone tried that and what was the outcome>
I haven't personally tried it, but have seen others on these forums talk about it. Basic info on the topic is to stop and disable SQL Server services, do the OS upgrade plus any reboots necessary for patches, then reset to automatic startup and start SQL Server services.
If you're having issue with memory though, consider moving to 64-bit rather than augmenting any 32-bit installations.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato -
Windows 2003 Std x86 will only support 4GB RAM max, this is a limit of the 32 bit address system. Enterprise edition will allow more RAM due to the PAE feature in this edition of the OS.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply