Link to home
Start Free TrialLog in
Avatar of anushahanna
anushahannaFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anushahanna

ASKER

Thanks for the helpful info.

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?

Yes.. You got it correctly..
If you have more memory with you, then you can cache more plans in your Procedure Cache..
Thanks for confirming it.
Welcome..