July 1, 2010 at 11:31 am
What other counter are good to check with PLE being this low.
I know my Ram is set to low. only 8 gigs max on a 200 gig server?go figure
I just need to prove it, and I could not explain the hit ratio...although my que length time are high, % Disk read time is pegged.
end of the day I still need more proof for the manager...to make a change?
thanks
July 1, 2010 at 1:51 pm
if anyone is woundering....here is a great link to the answer.
This explains buffer cache hit ratio well!
July 2, 2010 at 6:47 am
From the sounds of things, I'd be looking at the queries more than I'd be worrying about the amount of memory. Yes, you're hitting the cache & the buffer hard, but why? I'll bet you've got a lot of recompiles and the queries involve lots of scans. 8gb isn't lots of memory, but it's not a radically small amount either, especially for a system that's only 200gb of storage. Doubling the amount of memory isn't going to help much if your procs are the cause of the problem.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply