Post reply

Task Manager shows too much memory allocated...

  • November 25, 2002 at 2:01 pm

    #58737

    Hello all -

    My SQL Server 2000 SP2 server (on Win2K SP2) under

    Properties --> Memory

    has Running Values of 285 MB with "Reserve physical memory..." checked. However, task manager shows that sqlserve.exe has about 500 MB of memory allocated.

    Does anyone have an idea why/how a SQLServer could go above it's memory allocation definition?

    The Win2K box has been bounced several times since the memory was set at 285 MB.

    Thanks in advance for any help!!

    apf

  • November 26, 2002 at 12:47 am

    #442393

    Try putting w2k sp3

    or

    set value of fixed memory size to 256 mb and then check

    or

    set value of fixed memory size to 256 mb and then uncheck Reserve physical memory

    Hope one of the thing work for you....

    Prakash

    Prakash Heda
    Lead DBA Team - www.sqlfeatures.com
    Video sessions on Performance Tuning and SQL 2012 HA

  • November 26, 2002 at 4:33 am

    #442408

    Keep in mind "Reserve physical memory..." is supposed to keep at least that much available to SQL, so SQL should not drop below that point. 500 MB means it needed more that the reserve amount. Prakash is right in that either you need to set a Fixed memory size if you want SQL to use no more and no less, or adjust the dynamic allocation maximum.

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

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