In my recent post on the license changes in SQL Server 2008 R2, I deliberately didn’t cover the way the new features would be distributed across the various editions as at the time of writing the decisions simply hadn’t been made.
One of these new features is StreamInsight (the feature formerly known as Complex Event Processing) and I haven’t posted too much about it to date because I didn’t see it being a mainstream tool.
Before I go into that what exactly is StreamInsight?
Imagine you’ve just woken up this morning and all these annoying inputs are entering your brain:
Your body needs to react to all of this in the right way and often very quickly rather than simply remembering that this has all happened. If your body was running StreamInsight then you could set up a few rules to start your day:
So StreamInsight is a near real time monitoring and control framework able to respond to thousands of events a second. It does this by running in memory and it has the optional capability to write out what’s happened to database i.e. SQL Server.
It will have several applications from traditional manufacturing or environmental process monitoring and control, to biomedical applications and event stock market analysis.
StreamInsight is a development framework so there is nothing to see until you start to program in it, and one of the other reasons I have mentioned to much about before was that it was originally only going to be in the new DataCenter edition of SQL Server.
However it will be included in a limited form in standard edition, the limitation being a restriction on throughput rather than capability so code written for one edition will work on them all. This restriction will typically result in standard and enterprise editions being limited to about 5,000 events a second with greater than 5 second latency while DataCenter edition will be able to handle over triple this amount and have a far lower latency.
If that’s sounds interesting there a whole site on StreamInsight here and there are some sample apps on the StreamInsight blog here and you can download the November CTP of it here.
Interesting nugget about the standard editions - I wonder if this will make it viable/useful in smaller web applications? I posted my thoughts on StreamInsight yesterday... so explanations seem to be top of mind. http://consultingblogs.emc.com/simonmunro/archive/2010/01/25/where-microsoft-streaminsight-fits-in.aspx