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 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply