Detecting end-of-alarm/violation

Question

Hi,

We are developing an application to detect alarm (variable value going beyond limits) and end-of-alarm (variable value coming within limits after violation) conditions. The alarm output event is required to be generated after the boundary threshold period has elapsed (say 10 s). But the end-of-alarm output event should be generated as soon as the variable value comes within the limits.

I am able to generate the alarm output events properly (generates after 10 s), but the end-of-alarm output events are not getting generated immediately, they are also getting generated only after the threshold period has elapsed (10 s).

The query code and application details are available in another post here.

Please let me know what could be possible reason/solution for the same.

Regards,

Answer 1

In glancing at the queries in your original post, it looks like you should union the thresholdViolationSignal stream with the endOfViolations stream. The thresholdViolationSignal should give you what you are looking for because it clips the violation to the beginning of the non violation.

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.

Answer 2

Hello J,

I tried combining the different streams (thresholdViolation, thresholdViolationSignal, nonViolations) , but none of them seem to be giving the expected output. I also tried your approach of turning the alarms into edge events (http://www.devbiker.net/post/Cool-StreamInsight-querye28093turning-alarms-into-Edge-events.aspx). But with that as well, the end of alarm output is getting generated (received at output adapter) after 10 s.

My guess is that since the thresholdViolation or thresholdViolationSignal stream already has a delay of 10 s because of AlterEventLifeTime (for detecting violations), any other stream if unioned with them will also result in delay of 10 s.

Regards,

Answer 3

Hi Jayanta,

Have you found a solution? If you still need assistance, perhaps you should visit the below link to see the various paid support options that are available to better meet your needs.

http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

Thanks,

Cathy Miller