Post reply

Auto-close set to false, yet get "occurrence(s) of cachestore flush for the 'Bound Trees' " message

  • March 17, 2009 at 7:43 am

    #384145

    I get the following message on our development database each night before the restore process. I have checked Auto-close option and it is set to false, is there anything else that I can do to fix this?

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

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

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

    Thank you

  • March 17, 2009 at 7:56 am

    #961037

    A database restore will always flush the cache. No way to stop it from doing so.

    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

  • March 17, 2009 at 7:59 am

    #961039

    So we are OK with the flush even if auto close is set to false?

    Thanks Gila

  • March 17, 2009 at 8:05 am

    #961047

    eashoori (3/17/2009)

    So we are OK with the flush even if auto close is set to false?

    Sorry, not sure what you're asking here. Can you rephrase please?

    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

  • March 17, 2009 at 8:09 am

    #961052

    Gail,

    We both changed our original posts that pointed to the opposite thread so now both are available. I'll point the other thread to here again.:-D

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • March 17, 2009 at 8:11 am

    #961055

    As usual Gail is correct. Check out this article.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • March 17, 2009 at 9:15 am

    #961141

    Thanks both Jack and Gail.

    Also, Jack, I hope this is the right place to post for this thread.

    Thank you,

Viewing 7 posts - 1 through 6 (of 6 total)

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