Prakash.Bhojegowda (5/7/2008)
I called Microsoft and was on phone with them for 6 hours yesterday. They were not able to give me an explanantion. They turned around and said that, this is the way, SQL 2005 is designed to work.I still do not agree with Microsoft because, one of my friend who works for another IT firm do have SQL 2005 and he says that SQL 2005 should allocate all the available memory. If maximum 14 gigs of memory is configured on SQL SERVER, SQL should utlize every bit of it.
If any one has corrected the issue, please let me know, i shall be eager to know the solution.
Your friend is correct within certain contexts.
If you are using a 32bit version of SQL2005 then it will not use all the memory should PAE and AWE not be enabled.
On a 64bit system it will use all of the memory, however will not take all of that memory immediately, it will start off small and then ramp up as memory is needed, up to the maximum that it is allocated.