SQL Server Performance

SQL 2k Std on W2k Advanced

Discussion in 'Performance Tuning for Hardware Configurations' started by laserov, Jul 28, 2005.

  1. laserov New Member

    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.



    P.S. I looked for it in older topics, but this combination wasn't discussed, I think.
  2. gurucb New Member

    Yes It will use 2 GB but not more than that.
  3. ghemant Moderator

    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 />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
  4. joechang New Member

    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
  5. satya Moderator

    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.

Share This Page