March 11, 2005 at 8:29 am
How big can the proc cache grow to? Does it exist in awe or within the lower 4Gb ram?
My proc cache varies in size between 250Mb and just under 1Gb during the day but my cache hit ratio stays at 58%. I have 32Gb ram on the box.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
March 11, 2005 at 11:38 am
Proc cache is limited to 2GB (on 32 bit machines). The reason your cache hit ratio seems low is probably because you are looking at the "total" which is most likely being brought down by the "Execution Context" numbers.
Execution Context contains things like cursor position and parameter values, so even if you get a hit on your procedure cache, you could likely get a miss on execution context, giving you an artificially low overall ratio.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply