Design SI application

Category: sql server streaminsight


DevCode13 on Tue, 12 Mar 2013 05:44:37

I need to create an application using StreamInsight 2.1 and .Net.

Application should have below functionalities:

1) SI will run 24X7.

2) User can dynamically change the Source ,sink and query.

3) Performance implication.

How feasible to create such application?

Need some design guidlines of SI.

Thanks in Advance.


DevBiker on Tue, 12 Mar 2013 15:26:29

First, it's perfectly feasible. The hardest part is going to be the dynamic changing of the source, the sink and the query. How you would go about doing that depends on more detailed requirements than you've specified here ... but this is something that we've done with our framework @ Logica/CGI.

Performance is highly dependant on your available memory and CPU as well as the amount and complexity of the logic. That said, on a decent server system, we've seen SI (Premium) process over 100K events/second.