The Multifunctioning DBA

Dec 29 2010   10:00AM GMT

DB Mirror Alerts

Colin Smith Colin Smith Profile: Colin Smith

While I was back east at the home office I was asked to look into a way to monitor DB Mirroring. I had a couple thoughts on this as I know that I can look at the status of the mirror via SMO using Powershell and then alert if the status is not Synched. But I was in a time crunch so I did some quick searching thinking that someone had to have done something like this in the past and I was right, someone had and they were using a status change alert. Here is a link to what I found and I set it up and it does work.

I did the alert on state change event and like I said it does work. Just not as good as I would like. It seems to send out a lot of alerts and I think it is due to network Latency. So if it gets a bit behind the state changes and an alert goes out. Well that is great but I would like to verify that we really have an issue before sending out alerts so I am going to have that alert kick off a PS script that will wait about a minute and double check the state of the mirror. If it is still in a failed state then I will send out the notifications.

Thanks and I will post the script when it is complete.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: