Comments (6)

  1. Robert this is a great post. I’ve never had anyone ask about the plan cache in respect to mirroring. This is what I expect would be the case, but nice to have confirmation.

    1. Thanks Ryan!! In truth, I had never wondered about it until I saw someone asking today. That was why it interested me so much.

  2. […] on the principal and mirror when a failover occurs. My reply was starting to get long, so I… [full post] SQLSoldier SQLSoldier sql serverdatabase mirroringdynamic management viewshigh […]

  3. […] Czytaj więcej: Does a Mirroring Failover Clear the Procedure Cache? | SQLSoldier […]

  4. […] for their claim that the property had been enabled on the snapshot in the beginning. I recalled an earlier post I had done where I demonstrated that the cache for the database doesn’t get cleared when it […]

Leave a Reply