July 16, 2015 at 12:04 am
Hey,
what is better values for Buffer Cache Hot Ratio in SQL Server 2012.
is the values changed from 2008r2 to 2012?
July 16, 2015 at 1:10 am
Arjun SreeVastsva (7/16/2015)
Hey,what is better values for Buffer Cache Hot Ratio in SQL Server 2012.
is the values changed from 2008r2 to 2012?
Depends on few things but one aims as close to 100% as possible. If it drops below 90-95%, it normally is a sign of memory pressure.
No changes that I know of from the previous version, not understanding the question as the values are buffer hit ratios in percentage, cannot see how that would change.
😎
July 16, 2015 at 2:38 am
That counter has has no value at all.
You can have a server under severe memory pressure with that counter still sitting 99%. Ignore it, use other, more useful, counters.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply