One of the more important aspects of a large multi-site implementations is your database replication and obviously the health of this replication. We often talk about Vault replication as being set and forget and for the most part it is just that, running trouble free in the background....... until one day it’s not, and unfortunately if and when that one day comes all too many system admins are caught off guard.
In a typical business environment replication can fail for any number of reasons including of course site connectivity, network load, disk space, user security etc, so it’s important to stay on top of any changes that may affect this.
The WikiHelp article on Monitoring SQL Replication takes you through some of the Microsoft SQL monitoring tools and processes, providing background on some of the key performance indicators you should be monitoring to warn when replication is taking too long, the performance is slowed or site subscriptions are nearing expiration.
The article has a number of useful links to "how to" articles from Microsoft explaining how an administrator can use their tools to set up the monitoring features and thresholds discussed. A handy swag of information for any system administrator.
-Allan
Photo: mjtmail (tiggy)
Nice link on the unexpected deterioration of SQL replication.
No comments:
Post a Comment