February 6, 2011 at 6:28 pm
can some body please point me the list of db mirroring event ids like 1479 for time out , i need to monitor db mirroring suspend ,disconnect state etc...
February 7, 2011 at 10:22 am
sqlquery-101401 (2/6/2011)
can some body please point me the list of db mirroring event ids like 1479 for time out , i need to monitor db mirroring suspend ,disconnect state etc...
Not sure if this is exactly what you are asking for, but it should get you close.. Here is a list of database mirroring state change events:
http://msdn.microsoft.com/en-us/library/ms191502%28SQL.90%29.aspx
You can use these to set up alerts based on WMI event monitoring. I wrote about this on my blog at:
http://shaunjstuart.com/archive/2010/10/the-mirror-man/[/url]
Shaun
February 7, 2011 at 12:00 pm
Thanks , but i have scom to monitor my servers and currently it is monitoring event id 1479 for db mirror time out, are there any other in build event ids for Mirroring?
April 1, 2011 at 4:10 pm
April 1, 2011 at 4:11 pm
perfect ,thank you
April 1, 2011 at 4:45 pm
I've noticed a lot of the wmi state change events don't seem to have corresponding event IDs, like synchronizing and synchronized. I'm curious to know what you end up monitoring via the app log.
April 1, 2011 at 4:58 pm
This is better
select * from sys.messages where language_id = '1033' and text like '%mirror%' order by message_id
April 20, 2011 at 12:00 pm
Another thread requesting the same options:
http://www.sqlservercentral.com/Forums/Topic1096149-391-1.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply