August 28, 2008 at 5:47 pm
Hi Folks,
I am having a bit of difficulty understanding how target and total memory work even after reading doco.
My understanding is Target memory represents how much the buffer cache would like to use or maximum server memory (whichever is smaller).
Total server memory represents how much memory the buffer cache is actually using.
Therefore I come to the conclusion in the normal situation total should be less than target. It will never be more and if it is the same SQL needs more memory allocated to it.
Am I sounding sane?
August 29, 2008 at 8:04 am
Yes that is correct.
Target memory is amount of memory sql server can use while Total memory is amount
of memory sql server is using
How much memory do you have and what version you running?
August 30, 2008 at 6:35 pm
I have 16 GB of RAM on SQL 2005 64 bit. I think my max memory setting were wrong cos paging is crazy.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply