StreamInsight 1.2 - Asynchronous Queries RRS feed

  • Question

  • Hello,

    We have an application that is using StreamInsight in conjunction with OsiSoft PI in order to run calculations on incoming PI data.

    Our queries start and run, but they seem to the running sequentially instead of concurrently.  There are multiple calculations scheduled for different execution periods, but the execution of one stream appears to be blocking the others.

    We have a single input query servicing multiple calculation queries, and would like them to be able to run in parallel in order to react to time sensitive inputs from PI.  The calculation queries each filter the input stream for the pi events they are interested in, and produce output events specific to their respective calculations.

    The input adapter appears to be properly shared among the calculation queries through the eventual published stream.  For some reason though,calculation queries seem to block execution of the others until they have finished.

    Is there is anything in particular we could check within our query creation and other code that may be contributing to this behavior?  As we assumed that query executions would be independent of one another.

    Any information you could provide would be greatly appreciated.

    Thanks in advance.

    Wednesday, June 3, 2015 8:16 AM

All replies

  • After further searching it appears to be related to the version of the license associated with StreamInsight when registered using the SQL Server Key.

    We were using the Evaluation version originally during some parts of testing and development, which behaves like the Premium version of StreamInsight.  But it seems that the key associated with SQL Server is for Standard edition.

    The difference between Standard and Premium editions of StreamInsight being that Standard only has a single Query scheduler while Premium has a scheduler per core.

    A stupid limitation in my opinion, especially if you missed this in the fine print when selecting to use your SQL Server License to register StreamInsight.

    Oh well, will have to check with our managers to see if we are able to obtain a more appropriate license i suppose, if there is not some other workaround other than redesigning our current design to take this into account.


    • Edited by defiance Wednesday, June 3, 2015 3:21 PM
    Wednesday, June 3, 2015 3:20 PM