SQL 2k Std on W2k Advanced | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2k Std on W2k Advanced

Currently, I use W2k stdt edition + SQL 2k std ed. SQL uses about 1,7 GB. Will SQL 2k standard edition use the whole 2GB (if the server memory is 3GB) on W2k server advanced ? SQL 2k Enterprize is very expensive and will think about it later. Thanks, Martin P.S. I looked for it in older topics, but this combination wasn’t discussed, I think.
Yes It will use 2 GB but not more than that.
As BOL suggest you can utilize upto 2 gb memory on w2k std edition and w2k advance server can use upto 4 gb of ram : <br />read the link below :<br /><br /><a href=’http://support.microsoft.com/default.aspx?scid=kb;en-us;274750′ target=’_blank’ title=’http://support.microsoft.com/default.aspx?scid=kb;en-us;274750′<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;en-us;274750>http://support.microsoft.com/default.aspx?scid=kb;en-us;274750</a></a><br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7773&SearchTerms=temp,table’ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7773&SearchTerms=temp,table'<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7773&SearchTerms=temp>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7773&SearchTerms=temp</a>,table</a><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />regards<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
the reason it is not currently using more than 1.7G is that the SQL std user mode address space is 2GB, but 256M is allocated to things other than data buffers, hence its not used for physical memory,
switching to W2K AS or W2K3 EE will let the application use 3GB address space, but of course requires SQL EE.
so that alone won’t let you use more than the current 1.7G you might look at QuickShift, which provides an alternative method to allocating memory to SQL Server
This has been discussed many times in this forum so keep searching for further information also. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.