November 2, 2006 at 6:15 am
Hi all,
According to Microsoft website, it says that SQL 2005 Standard edition is not restricted to memory use on a windows 2003 server installation.
So for example, if one has a windows 2003 Ent operating system with 8GB of memory, does this mean that without making any configuration changes SQL server 2005 standard edition can make use of the entire 8GB of memory.
OR
Is there any configuration that has to be changed to make use of all the memory, if so what is this and can you explain how the setting is to be configured.
Thanks
November 2, 2006 at 9:19 am
If you are using the 32bit version of Windows, you'll still need the /pae switch in the boot.ini file to make use of the extra RAM in most cases.
By saying that SQL Server Standard Edition is not restricted in terms of RAM is true, but a bit misleading too. SQL Server itself has no arbitrary limit, but the OS that you run it under does, so the limiting factor is the OS.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
November 3, 2006 at 4:52 am
Don't forget to allow space for the OS. SQL can steal it all creating a whole host of problems.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply