SQL Server DB Mirroring Management Pack
Posted by rburri on June, 5 2010
My latest addition to the community MP catalog augments the SQL Server MP with database mirroring discovery and monitoring. The SQL Server DB Mirroring Management Pack helps you by:
- discovering db mirror roles and objects on SQL 2008 DB engines
- automatically creating service components per mirrored database (consider them mini DADs)
- probe based monitoring of the mirrored DB state with alerting should the mirror no longer run synchronized or loose its witness
- optionally checking the mirror mode and db roles against a Desired Configuration setting (alerts when the mirror roles are swapped etc.)
- delivering mirror inventory and availability reports
DB Mirroring Relationships and Health Roll Up
The Management Pack comes with a comprehensive guide which is a must read. The pack will only work as expected if some prerequisites are met. The guide also discusses how to enable Desired Configuration monitoring for your DB mirrors.
Get the SQL Server DB Mirroring MP from SystemCenterCentral.com (Version 126.96.36.199)
The download also contains an override MP for the SQL Server Extension MP published on OpsMgr Jam. The extension MP already features useful event and performance collection rules that help monitoring an SQL DB mirror but as it does not contain any discoveries, they are targeting any SQL server. My override MP helps by adjusting their targeting so that those rules are only active on SQL Engines that host mirrored DBs.
2010 Management Pack Extension Contest
South Africa 2010 is about to take off and even on planet SCOM we currently have a great tournament:
- diagram or service level
- Visio or Dashboard
- by tuning it
My own MP does certainly extend the SQL Server Management Pack and it does fit more or less into three of the contest categories. The deadline for entries is June 30, 2010. So why don’t you upload your own entries to compete with me?