Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mirror database monitoring Expand / Collapse
Author
Message
Posted Friday, July 25, 2014 5:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:13 AM
Points: 367, Visits: 443
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?
Post #1596156
Posted Friday, July 25, 2014 10:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:48 AM
Points: 2,057, Visits: 3,578
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
Post #1596314
Posted Monday, July 28, 2014 1:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:13 AM
Points: 367, Visits: 443
Thanks Gazareth, I'll have a look now I'm back at work.
Post #1596714
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse