Post reply

Sql 2000 memory question

  • November 26, 2006 at 1:25 pm

    #75100

    when i did right click on (Console Root)server properties from Enterprise Manager & then click on Memory, it is Dynamic Mem Allocation. (0-1015MB)

    When i did sp_configure from QA(master) i am seeing this & will like to know difference between EM & QA.

    name                       minimum     maximum        config_value     run_value  

    ----------------------------------- ----------- ----------- ------------ ---

    max server memory (MB)   4         2147483647    2147483647     2147483647

    I am missing something over here. any help is appreciated & thanking in advance.

  • November 26, 2006 at 3:19 pm

    #673954

    The results you see from QA is the default when you have dynamic mem set. If you were to set a hard limit in EM you should see the same in QA- I beleive EM is showing you the total actual available on the machine per the OS..

    Thanks

    Rich

  • November 26, 2006 at 3:42 pm

    #673956

    thanks for your reply. i would like to know what is this number "2147483647" & from where this is coming from, also if you have memory more than 4GB still it shows config_value & run_value  as "2147483647".

  • November 26, 2006 at 4:33 pm

    #673958

    I believe it is 2GB in bytes. If you have 4GB in the box you need to have the /3GB switch in your boot.ini to allow sql to grab that extra memory.. just be careful you aren't running much of anything on the server alongside sql or you could run into problems.. I think we had to allocate the 3GB to sql for it to use it on some of our boxes. Its been a while

    Thanks

    Rich

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply