Memory allocation in Win XP pro | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Memory allocation in Win XP pro

Running Win XP pro sp2 w/ 1.5 gb ram on AMD processor. Will be installing an extra 1.5 GB soon.
How do I reset boot ini file to accept this ram increase?
Please take it slow as barely computer literate! Thanks. Jack Jack Yonn
With XP you can only install SQL2000 Personal.
SQL 2000 Personal was desing to work with one user or two. More than that, performance decrease.
SQL 2000 Personal can reach 2GB, no more. HTH Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Hi,<br />if you would set to RAM amount in OS then you have to follow the step as :<br /><br />My Computer -&gt; properties -&gt; Advance -&gt; Performance -&gt; Settings -&gt; Advance -&gt; Virtual Memory – Change -&gt; Custom : Intial Ram (Actual Phyzical Disk * 150% ) & Maximum Ram (Actual Phyzical Disk * 200%)<br /><br />and if you wants to configure the SQL Server Ram (not support more then 2 GB on MSDE)<br />run <b><font color="brown">sp_configure </font id="brown"> </b> <br />and if you wants to use AWE please read <b><font color="red">Managing AWE Memory</font id="red"></b> in BOOKS ONLINE.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards.<br />hsGoswami<br />[email protected]
If the edition of SQL is not a Standard or Enterprise then there will not be much use of adding physical memory, as it is possible only when you use server edition of operating system and defined edition of SQL server. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.