Monitoring a SQL 2008 R2 Mirror using SAM

Is there a way to use SAM to monitor a Microsoft SQL 2008 R2 mirror? I have a user that needs to know when a SQL mirror fails over and I cannot figure out how to do it using SAM. I saw a few things here at Thwack, but nothing I could use for this.

Any help is appreciated.

- Dave Claussen

Find more posts tagged with

sam

sql

mirror

Accepted answers

All comments

aLTeReGo

The simplest and most elegant way would likely be to use the Windows Event Log Monitor and trigger an alert whenever a failover message is written to the even log.

mrmmills

See the following post: http://thwack.solarwinds.com/message/210231 on using TSQL or Powershell to monitor SQL db mirroring in SolarWinds, I started a new post because this may get lengthy...

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of