SQL Server Performance Forum – Threads Archive
memory problem
hii have sql server with 3 gb ram. OS is windows standart server. sql is sql enterprise
i cannot use all memory, only 2 gb. according to chart inhttp://www.sql-server-performance.com/awe_memory.asp i can use 4 gb ram with this conf. i tried to write /3gb switch in boot.ini but it is only needed when i have 4 gb ram. so what can i do? thanks
Your information is not clear, could you please confirm the Operating system version and service pack level. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
my os is windows 2000 server (not advanced server) sp4
sql enterprise server with sp 4 and with awe bugfix installed http://support.microsoft.com/default.aspx?kbid=899761)
3 gb memory
2x cpu
thanks
KBA
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
i read the document NOTE: You cannot allocate more than 4 GB of physical memory to an application on Windows 2000 Server because Physical Address Extension (PAE) is not available on Microsoft Windows 2000 Server. Also, you cannot use the 3 GB switch in the Boot.ini file with Windows 2000 Server; however, you can use the 3 GB switch in the Boot.ini file with Microsoft Windows 2000 Advanced Server or Microsoft Windows Datacenter versions. For additional information, click the following article number to view the article in the Microsoft Knowledge Base sql server is awe enabled.
awe enabled011 i changed the boot.ini and wrote /3gb. is it my fault? and if i clean /3gb will it be Ok?
Yes you can try that bit too. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
i think i have to upgrade to advanced server: http://support.microsoft.com/kb/291988/
Using the /3GB switch from the Boot.ini file with Windows 2000 Professional or with Windows 2000 Server can give the appearance of a 3 GB range of user-mode memory. However, the memory from 0x80000000 through 0xBFFFFFFF is not usable. Because kernel-mode components are now limited to using from 0xC0000000 through 0xFFFFFFF memory range, developers can test kernel-mode components.
]]>