Forum Discussion

wnite's avatar
wnite
Icon for Neophyte rankNeophyte
2 months ago

Dynamic Alerting/Threshold Setup

Hi, I've just started experimenting with Dynamic alerting, probably something I should have done ages ago! I've read the documentation and been through the training module.

I'm experimenting with the SQL Server Global Performance LogicModule which seems a good candidate for this, we get a fair bit of alert noise from this in our environment. I've gone into the Global definition for this module and turned on dynamic alerting for any of the datapoints that have a static threshold alert set. Seems to be working nicely.

I've set the Dynamic threshold to suppress notifications, but what is the best way to remove the static threshold all together. I'm not too keen on just deleting them from LogicModule.

I suppose one approach could be to duplicate the LogicModule, and modify deleting the static thresholds that one so that my original one is still intact in case I want to go back to it for refer to what the static values were set too. Then disable the original LogicModule.

I don't really want the static alert threshold showing up in my alert list at all.

Another thing that would be nice (Let me know if it's already there) would be if I was able to see at a glance if an alert had been triggered by a breach in dynamic or static threshold?

dynamic thresholds

3 Replies

  • wnite's avatar
    wnite
    Icon for Neophyte rankNeophyte
    2 months ago

    Thanks, that's a good idea I can see that would work. The only thing that wouldn't achieve is getting rid of the static alert notifications all together. Unless I'm missing something the only way I can see to do this is to modify the LogicModule.

    I have tried this in the way described above and it does see to do what I want.

    • jhupka's avatar
      jhupka
      Icon for Neophyte rankNeophyte
      2 months ago

      The only way I can think of to "get rid of" the static alert using this layout would be to add your Dynamic thresholds at the resource/group level, and then also set a dummy Static thresholds to something that won't ever get triggered.

  • jhupka's avatar
    jhupka
    Icon for Neophyte rankNeophyte
    2 months ago

    For the devices you're most interested in doing these tunings on, can you place them in their own Resource Group(s)?  Either a static or dynamic Resource Group works - then you can do the tuning of these parameters on the Alert Tuning tab of the Resource Group instead of the Datasource itself. 

    Doing the tuning this way helps with a couple things:
    - You won't have to worry about deleting/modifying anything globally in your environment 
    - When updating your Logic Modules, while it is easy to retain these tunings when updating, not doing it on the module simplifies the upgrading by a button click or two