anushahanna
asked on
cache in memory
What is the default time for SQL cache to be in physical Memory?
and is it possible to increase this limit (apart from increasing memory)?
thanks
and is it possible to increase this limit (apart from increasing memory)?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes.. You got it correctly..
If you have more memory with you, then you can cache more plans in your Procedure Cache..
If you have more memory with you, then you can cache more plans in your Procedure Cache..
ASKER
Thanks for confirming it.
Welcome..
ASKER
So, it is possible that only limited MRU is cached, if enough memory is not available, right? and we do not to worry about LRU since it is not helpful and system takes care of it?