have sql 2000 Ent running on Win 2003. My Cache hit ratio is running around 66%. TIme for more memory? Also, is there a way to show what specific objects are chewing up memory? This is 3rd party apps so changing app not an option
Printable View
have sql 2000 Ent running on Win 2003. My Cache hit ratio is running around 66%. TIme for more memory? Also, is there a way to show what specific objects are chewing up memory? This is 3rd party apps so changing app not an option
How about buffer cache hit ratio? That's data cache and should be above 95%.
It's about 95-96, I have not seen this kind of a large disparity between these 2 before
Cache hit ratio is for sql procedures, not for data. I'll add more memory on it since I like to see above 99% of buffer cache hit ratio.