Post reply

Getting Cache Flush messages on sql 2005 standby server during restore of transaction log

  • February 18, 2010 at 8:49 am

    #230072

    I am getting these messages below on a failover server that has several databases with logshipping restore operations running.

    1. SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

    2. SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

    3. SQL Server has encountered 12 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

    Is this anything to be concerned about?

  • February 18, 2010 at 9:17 am

    #1120993

    The caches are flushed whenever a restore occurs. This includes restores of transaction logs.

    It might be something to worry about if you're using the secondary as a reporting server, but there is nothing you can do about it. A restore will always flush the caches.

    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

  • February 18, 2010 at 9:19 am

    #1120996

    Thanks Gail for the quick response. Most appreciated!

    Patti

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply