posted 7/20/2010 by MarkGStacey - Views: [1605]
StreamInsight comes in 2 versions, Standard (on web, Standard and Enterprise editions) , and Premium (on DataCenter edition)
Microsoft's documentation says Std is good for up to 5000 events per second, and a latency of more than 5 seconds, whereas Premium will run more than 5000 events per second and a latency of less than 5 seconds. Depending on hardware of course.
So what's the difference?
As it turns out (and undocumented....), the core query engine in Std is essentially single-threaded, and the core query engine in Premium is parallelised.
The numbers above come from some empirical testing.
So, if you're processing multiple input streams, doing the filtering in seperate instances, and then combining downstream in another instance may well be beneficial if you're running standard. Not my advice, MS platform rep :-)