Page Life Expectancy low vs Buffer Cache hit Ratio High

• Oliveira, Douglas

  SSC Enthusiast

  Points: 162

  More actions

  October 7, 2010 at 8:12 am

  #229143

  Hi everybody!

  I have a problem with my server Sql 2005. I see on the perfmon and my page life expectancy was very low, the average is 112 but in some moments it goes a 20 and while the buffer cache hit ratio always in 99.8.

  I dont know if the problems was related a memory, because the high buffer cache hit ratio. The average of the cache hit ratio is 90, 91. Anyone know what can be?

  []'s
  Douglas R. Oliveira

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 7, 2010 at 8:14 am

  #1233604

  Very strange. It's a question I don't see very often and we got two today.

  Here's the other one.

  -- Gianluca Sartori

• Oliveira, Douglas

  SSC Enthusiast

  Points: 162

  More actions

  October 8, 2010 at 10:55 am

  #1234388

  Thanks...

  I go following this topic.

  []'s
  Douglas R. Oliveira