Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Buffer cache hit ratio down.. Expand / Collapse
Author
Message
Posted Monday, June 17, 2013 5:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:53 AM
Points: 209, Visits: 573
Gila Monster, Can you please answer my questions ?
========================================
Hello Guys,

I analysed one thing, the machine which is facing low cache hit ratio issue is in cluster and its currently in passive mode. On active node everything is fine which should be. In the past we did not recieved any such alerts from any cluster.

Now my question is
What should be the cache hit ratio of Passive node ? should be 0% ?
why we recieved low cache hit ratio alerts for PASSIVE NODE ?
Is cache hit ratio of Passive node should be low OR 0% ?

Thanks in advance,
Jitendra
Post #1464096
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse