Post reply

Does dropping a database clear any proc cache and or data cache for the db from memory

  • March 31, 2011 at 1:03 pm

    #237750

    Does dropping a database clear any proc cache and or data cache for the db from memory? i would think that even if it doesn't clear the cache, the cache that exists is not valid. The reason I ask is that in our dev system a db was assigned to the incorrect drive. Another dba dropped\detached the db and then restored (or reattached not sure) the db. I am curious if the cache is still valid. Anyone know of any documentation on data and proc cache and what happens if you drop\detach then restore\attach a db?

    Jimmy

    "I'm still learning the things i thought i knew!"

  • March 31, 2011 at 2:34 pm

    #1306205

    It clears both. As does detach, restore, offline.

    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

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

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