November 4, 2002 at 3:50 pm
So is it ok to have the max memory slider maxed if I'm using dynamic memory management?
November 4, 2002 at 4:26 pm
I would leave at least 64 MB so the OS has some play should an issue arise as you don't choke it to death. If ample memory then better to leave 128 or even 256 mb.
November 4, 2002 at 5:48 pm
Cool. Thanks. That was my initial thought but some of the other stuff I read made me second guess.
November 4, 2002 at 5:52 pm
One other thing. I've got dynamic memory management enabled. The server has 2 gig and is not running other apps. The minimum mem is set to 0 with the max set to 1792. I'm not seeing and paging and the cache buffer hit ratio is like 98%. Are these settings ok? And what about the minimum query memory setting? Should that be left at 1024?
November 4, 2002 at 8:06 pm
Yes cache buffer hit should be above 90% consitantly or you have a memory issue. Other than that, the rest sounds fine. SQL will take memory as it needs and free only when directed by the OS so 0 to 1792 is great. Not seen any improvement in testing with minimum query setting changes, someone else may want to jump in if they have (you still might want to play if no production).
November 5, 2002 at 5:46 am
If you change the 'minimum query setting' remember it is KB not bytes.
I have in the past found it set far too high which sort of killed the server.
Steven
November 5, 2002 at 10:24 am
Thanks everybody!!!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply