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