SQL Server Performance

win 2003 x64 + sql 2005 ctp + memory

Discussion in 'Performance Tuning for Hardware Configurations' started by webforum2000, Apr 29, 2005.

  1. webforum2000 New Member

    Hi Guys,
    I installed x64 bit windows server 2005 enterprise edition on a dual processor xenon processor machine with 8gb ram. I installed sql 2005 64 bit CTP (Beta 2)on it.
    I would like to test SQLperformance on this particular box when indexing. Is there a way for sql to recognize all 8gbOF RAM AND make use of it. I tried to allocate sql to use 6gb of ram ..but it reverts back to the 2gb limit. Is there a limitation? How do I go about setting sql to use all the ram? I dont see sql using all the ram through task manager ... Any insgiht into this will be appreciated a lot.
    Thanks in advance.
  2. Luis Martin Moderator

    Since 2005 is B, I suppose that you have to way until finish release.
    I think 2000 has differents versions, so why 2005 not?

    Luis Martin

    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.

  3. satya Moderator

    Check the edition of operating system, is it Windows adv. server or windows 2000 server?

    SQL Server 2005 dynamically allocates AWE-mapped memory when running with any of the Windows Server 2003 operating system editions. In other words, the buffer pool can dynamically manage AWE-mapped memory to balance SQL Server memory use with the overall system requirements.

    To monitor for a low-memory condition, start with the following object counters:

    Memory: Available Bytes
    Memory: Pages/sec

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. webforum2000 New Member

    thank you guys. I did run a query that takes a long time. The memory allocated automatically started increasing till it reached the maximum available on the server in this case 7.5gb (out of 8gb). It dows work..sorry for nor updating the status earlier.
    on this note: Hope fully developed version will be more powerful.. I did not see much of a increase in performance. I will further investigate my disk bottle neck (Which I dont htink they are)... and keep you posted.
  5. derrickleggett New Member

    What exactly were you trying to do? Any 2005 stats you can give would be appreciated. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.

Share This Page