KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

SQL Mirror backup monitoring

 
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting
View previous topic :: View next topic  
Author Message
jivetolkein



Joined: 19 Jul 2007
Posts: 96

PostPosted: Thu Mar 15, 2012 6:25 am    Post subject: SQL Mirror backup monitoring Reply with quote

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
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Thu Mar 15, 2012 6:57 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
jivetolkein



Joined: 19 Jul 2007
Posts: 96

PostPosted: Thu Mar 15, 2012 8:57 am    Post subject: Reply with quote

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
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Thu Mar 15, 2012 10:33 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
jivetolkein



Joined: 19 Jul 2007
Posts: 96

PostPosted: Fri Mar 16, 2012 3:16 am    Post subject: Reply with quote

Ah, I see. A subtle difference but important - thanks for following this up!
Back to top
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Fri Mar 16, 2012 9:04 am    Post subject: Reply with quote

You are welcome !
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Configuration, Maintenance, Troubleshooting All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index