SQL Express 2005 problem

• Shailesh Chaudhary

  Old Hand

  Points: 377

  More actions

  December 4, 2008 at 3:20 pm

  #128332

  I have SQL express 2005 and it was working good but suddenly start giving the problem of

  "SQL Server has encountered 4 occurences of cache store flush for the object plans cacestore (Part of plan cache) due to some database maintence or reconfigure operations. "

  I did not understand why this error came up and it is filling the vent log in every two minutes. I tried everything like Detaching database abnd then attaching it again. Drop the databse and then resore it again but this error is not going away.

  Any help will be appriciated. Database name is 'AFR'

  Thanks

  sc

• GSquared

  SSC Guru

  Points: 260824

  More actions

  December 4, 2008 at 3:33 pm

  #907980

  I found some data about that error at:

  http://sqlserver-qa.net/blogs/perftune/archive/2007/05/14/sql-server-has-encountered-occurrence-s-of-cachestore-flush-for-the-cachestore.aspx

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  December 4, 2008 at 4:26 pm

  #908003

  and here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3074939&SiteID=1

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  December 5, 2008 at 1:32 am

  #908096

  Database restores (including log restores)

  Autoclose (a good candidate on SQL Express)

  Some sp_configure alterations

  DBCC FREEPROCCACHE

  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

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass