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?
wnite
OP10 months agoThanks, 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.
Jason Hupka
·10 months agoThe 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.