Monday, March 19, 2012

dmvs and mirroring

All,

My current understanding is that most, if not all dmv's are dynamic in that if a server is rebooted than the information gathered from the dmv's will be reset. What happens if the mirror instance fails over (manually or because of a hardward/software issue)? Does the failover of the principal to the mirror node cause the a resetting of the dmvs?

Thanks,

Ian

Hi Ian,

The DMVs are dynamic are always changing as the internal/external structures of the database/server change.

Jag

No comments:

Post a Comment