lucjad
15 days agoNeophyte
Static Thresholds
I am trying to set static threshold for SQL Server Databases, State at the group level. My criteria is to set warning for any value but 0 (online), and Error for 4-6 (Suspect, Emergency, Offline). I ...
What are the valid range of State values? If it's 0-6 then something like using ">0 3" (or >=1 4) would work. That will cause a warning if 1, 2, or 3, and an error if it's 4, 5, or 6.
Unfortunately you can't directly mix different operations in the same threshold, like you can't have "!=0, >3 3". But if you need to deal with say negative status codes also causing warnings. You may need to create a custom Complex DataPoint that either changes around the status codes (like say changing OK to -10 instead of 0) or even creating a Complex DataPoint that only returns 0 (OK), 1 (warning), or 2 (error) with what conditions you want. Note that doing the last one doesn't provide a lot of flexibility for tuning though.