SentryOne Team Blog (blogs.sentryone.com)

Tag : database mirroring

Database Mirroring : Monitoring and Automation with SQL Sentry

Since its introduction in SQL Server 2005 SP1, mirroring has become a common method to provide high availability for critical databases. With any HA strategy, proper monitoring is a must to ensure everything is working as planned with minimal data loss and disruption incurred in the event of a failover.

SQL Server has built-in methods to monitor database mirroring, but there are several limitations and known issues. I'll show you how to use SQL Sentry's software to work around those and gain much more insight and visibility into your database mirroring performance.