Customized an Alarm for specific days

Hello,

it should be possible to change the condition of the rule so it triggers differently depends on the day of the week.
But you need to do some coding. One option I can image is adding an if/else structure in the condition like:
if (Monday-Friday){
     Condition 1
     }
else {
    Condition 2
    }

I'm not sure how familiar you are with coding. If needed you can involve our PSO team to get this done. Contact your Quest account manager he/she can provide further details about PSO consultant.

I hope that helps.

Let's see if someone else if having further ideas for this request.

Kind Regards

Nicola

Thanks for your feedback Nicola.

The point is that setting up conditions on the rule will have a global scope 

and most likely there is a need to have another registry variable (for the weekend), right?.

I notice that the default code in rule is the following and have just one fixed registry variable (DBSS-LocksDeadlocks_Low):

condition = (#number_of_deadlocks# >= registry("DBSS-LocksDeadlocks_Low"));
return Dbwc_Common_SQL_Server_IsNeedToSendAlarm(scope, "DBSS - Deadlocks", "2", condition);

The idea is to customize the alarm for days and for instance.

I wonder if I can have two deadlocks rules (both copied from the original and add a blockout for the week and weekend so so they can work accordingly)

I wonder if my approach to customize the deadlock alarm make sense taking into consideration the metrics i get from health check report.

Or Is there any other approach that fit better  based on Foglight Features?

Thanks

Thanks for your feedback Nicola.

The point is that setting up conditions on the rule will have a global scope 

and most likely there is a need to have another registry variable (for the weekend), right?.

I notice that the default code in rule is the following and have just one fixed registry variable (DBSS-LocksDeadlocks_Low):

condition = (#number_of_deadlocks# >= registry("DBSS-LocksDeadlocks_Low"));
return Dbwc_Common_SQL_Server_IsNeedToSendAlarm(scope, "DBSS - Deadlocks", "2", condition);

The idea is to customize the alarm for days and for instance.

I wonder if I can have two deadlocks rules (both copied from the original and add a blockout for the week and weekend so so they can work accordingly)

I wonder if my approach to customize the deadlock alarm make sense taking into consideration the metrics i get from health check report.

Or Is there any other approach that fit better  based on Foglight Features?

Thanks

Registry variables can be scoped to an object (eg. instance) and/or scheduled.

So you could have a value for the schedule "weekday" and a different value for the schedule "weekend". You could even do this on a per instance basis if needed. 

It seems interesting this option.

What Topology Type should i use to customize the value of a Registry Variable ?

There are many when I want to add a registry value. Can i set the value for a specific database as well ?

Thanks in advance

Hi,

I wrote a couple blogs that go thru the mechanics of doing this. I can take a closer look at the specific case (deadlocks) if needed.

https://www.quest.com/community/blogs/b/performance-monitoring/posts/setting-different-alarm-thresholds-for-different-hosts

https://www.quest.com/community/blogs/b/performance-monitoring/posts/setting-email-to-different-address-at-different-times-of-day

Thanks Darren, I really appreciate your help. I will take a look at them