November 25, 2002 at 2:01 pm
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
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
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