Mirror database monitoring

  • Hi all

    We've got a mirrored database on one of our servers and there's a mirrored database monitoring job set up.

    As far as I can see, all it does it write data to a table.

    Now, I've got a couple of questions:-

    Can I set this job up to email if the originating mirror goes down? If so, has anyone got any pointers? The job runs every minute but I don't want to get bombarded with emails if it does (every 15 minutes will be plenty).

    I can see the table in the MSDB database, but I'm not sure what the "Status" field is for. Anyone got any useful links as I'm obviously not searching the correct terms on Google?

    I know the originating mirror went down yesterday (it was rebooted), but I can't see any evidence of that for the correct time-frame?

    Anyone any pointers on reading the dbm_monitor_data table please?

  • Hi Richard,

    You can set up a WMI alert in SQL Agent to notify you when mirroring state changes, see the Database Mirroring State Change Events section here:

    http://technet.microsoft.com/en-us/library/cc966392.aspx

    There's also a script for a table & job that'll record state change history.

    I've used these before, very useful. I do recommend limiting the alert to only certain state changes though.

    Cheers

    Gaz

  • Thanks Gazareth, I'll have a look now I'm back at work.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply