With Microsoft StreamInsight in SQL Server 2008 R2, Microsoft started to make Complex Event Processing capabilities available in Microsoft’s data platform. The SQL Server team announced that the upcoming SQL Server Code Name “Denali” release will include key improvements for StreamInsight:
- Resiliency against planned and unplanned downtime through checkpointing
The new resiliency features in StreamInsight let you run your mission-critical applications with tolerance to system failures and minimal operational downtime. It supports query recovery from failure by periodically checkpointing query state during normal operations. After the outage, the query recovers its query state from the last persisted checkpoint.
- Improved development experience through support for nested event type structures and additional LINQ expressions
Previously, StreamInsight event types needed to be flat lists of payload fields. The new version of StreamInsight enables users to express event types as nested structures, reducing the friction between your native event schemas and their representation in StreamInsight. A number of other improvements – like n-way joins, nested queries, and support for query macros – enhance the developer experience.
- Better support for predictive modeling and pattern matching scenarios through new user-defined stream operators
A user-defined stream operator, or UDSO as the team affectionately calls the feature, lets you interact with an event stream in a procedural way. Unlike previous extensibility interfaces, UDSOs are not bound to StreamInsight windows, and can maintain their own state.
- Improved administrator experience through performance counters
and event log
In previous versions, StreamInsight runtime diagnostics were only available through StreamInsight’s diagnostic views. In this release, StreamInsight introduces support for diagnostics through the standard Windows performance counter infrastructure. This makes it easy to monitor the health and performance of StreamInsight applications using well-established tools, such as Performance Monitor. The new administrative event log in turn records administrative events and errors, which can be discovered, explored, and used via system tools such as Windows Event Viewer.
You can download StreamInsight 1.2 directly from Microsoft Download Center.