View previous topic :: View next topic |
Author |
Message |
jivetolkein
Joined: 19 Jul 2007 Posts: 96
|
Posted: Thu Mar 15, 2012 6:25 am Post subject: SQL Mirror backup monitoring |
|
|
Hi All,
A little problem that I'm struggling to solve in HM
We have an active/passive MS SQL database mirror running on two hosts.
We monitor these hosts for backup and transaction log backups. Of course the passive partner doesn't do any transaction log backups, as it doesn't need too. So the test is always failed .. but if its partners is OK, this is no problem. The database can switch to it's mirror partner for some time so it's not predictable which will be 'Active'.
So is there an elegant way to make a tests status depend on the status of another, and can it be two way (i.e. a logical OR of the tests status, and set both to the result with Good = 1 Bad = 0)
Cheers for any ideas |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Thu Mar 15, 2012 6:57 am Post subject: |
|
|
You may use "Use Normal status if" option for both tests.
E.g. test named "TestActiveSQL" may use "Use Normal status if" option with expression like the following:
('%SuggestedSimpleStatus%'=='DOWN') AND ('%::TestPassiveSQL::SimpleStatus%'=='UP')
And vice verse: "Use Normal status if" option for test, named "TestPassiveSQL" may look like:
('%SuggestedSimpleStatus%'=='DOWN') AND ('%::TestActiveSQL::SimpleStatus%'=='UP')
With these option enabled, when one of test items will get "Bad" status, while another is "Ok", first test will get Normal status and no alerts will be triggered.
Also, you may use Master/Dependent tests.
E.g. "TestActiveSQL" may be set as Master test for "TestPassiveSQL".
Please check the manual or visit our web site for more information at:
Use Normal status option: http://www.ks-soft.net/hostmon.eng/mframe.htm#tests.htm#normalstatus
Master/Dependent tests: http://www.ks-soft.net/hostmon.eng/mframe.htm#tests.htm#Master |
|
Back to top |
|
|
jivetolkein
Joined: 19 Jul 2007 Posts: 96
|
Posted: Thu Mar 15, 2012 8:57 am Post subject: |
|
|
Perfect, thank you - option 1 is what I was looking for.
The problem with option 2 is that either test could conceivably be the Active copy of the db server .. so the master / dependant order would have to change. |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Thu Mar 15, 2012 10:33 am Post subject: |
|
|
Maybe not so perfect....
"Normal" status is considered as "UP", so in case of two test are "Bad", both of them will become Normal.
It would be correct to use exect test status insteas of simple status:
"Use Normal status if" expression for "TestActiveSQL":
('%SuggestedSimpleStatus%'=='DOWN') AND ('%::TestPassiveSQL::Status%'=='Ok')
"Use Normal status if" expression for "TestPassiveSQL":
('%SuggestedSimpleStatus%'=='DOWN') AND ('%::TestActiveSQL::Status%'=='Ok')
Please note: some test methods may return Good status that differs from 'Ok' (E.g. Ping test returns Host is alive status). In such case just change this in expression. |
|
Back to top |
|
|
jivetolkein
Joined: 19 Jul 2007 Posts: 96
|
Posted: Fri Mar 16, 2012 3:16 am Post subject: |
|
|
Ah, I see. A subtle difference but important - thanks for following this up! |
|
Back to top |
|
|
KS-Soft Europe
Joined: 16 May 2006 Posts: 2832
|
Posted: Fri Mar 16, 2012 9:04 am Post subject: |
|
|
You are welcome ! |
|
Back to top |
|
|
|