win 2003 x64 + sql 2005 ctp + memory | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

win 2003 x64 + sql 2005 ctp + memory

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.
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
Moderator
SQL-Server-Performance.com 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.
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
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.
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 />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
]]>