Microsoft® SQL Server® StreamInsight 1.2

Select Language:
Microsoft® StreamInsight is Microsoft’s Complex Event Processing technology to help businesses create event-driven applications and derive better insights by correlating event streams from multiple sources with near-zero latency.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:





    Date Published:


    File Size:

    6.4 MB

    9.5 MB

    9.3 MB

    6.2 MB

      Microsoft® StreamInsight is a platform that enables the continuous and incremental processing of unbounded sequences of events (event streams) from multiple sources with near-zero latency. These requirements, shared by vertical markets such as manufacturing, oil and gas, utilities, financial services, health care, web analytics, and IT and data center monitoring, make traditional store and query techniques impractical for event driven, timely and relevant processing of data. The ability to monitor, analyze and act on data in motion provides significant opportunity to make more informed business decisions in near real-time.

      Further resources can be found on the MSDN Portal, on the StreamInsight Blog, and on CodePlex.

      These are the new features in StreamInsight 1.2:
      • Resiliency against planned and unplanned downtime through checkpointing. Custom solutions to work around the problem of resiliency have typically been expensive to implement, and limited in their ability to prevent data loss and guarantee correctness of output after recovery. The new resiliency features in StreamInsight let you run your critical applications with tolerance to system failures and minimal operational downtime. StreamInsight resiliency supports recovering query state from the failure checkpointing system state at specific points in time during normal operations. After a failure, the query is made operational again by recovering the query state from this persisted store.
      • 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 them, lets the user interact with the event stream in a procedural way. Unlike previous extensibility interfaces, they are not bound to a window, and can maintain their own state. A user-defined stream operator ingests a single event at a time and can produce one or more result events for each such input.
      • Improved administrator experience through performance counters. In previous versions, StreamInsight runtime diagnostics needed to be obtained from the engine’s diagnostic views. This new feature provides performance counter information, published through the Windows performance counter infrastructure, which can help monitor the health and performance of StreamInsight applications using well-established tools, such as Performance Monitor.
      • Improved administrator experience through the administrative event log. The new administrative event log records administrative events and errors in the StreamInsight engine, which can be discovered, explored, and used via system tools such as Event Viewer. These events register state changes that can help system administrators understand the behavior of a StreamInsight application and react to state changes in StreamInsight components such as adapters, queries, and the engine, or investigate the unexpected shutdown of a query.
      • 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 the StreamInsight framework. Users can work with nested event types in the input and output adapters as well as in StreamInsight LINQ. A number of other improvements—like n-way joins, nested queries, and support for query macros—enhance the developer experience.

      The Microsoft® StreamInsight Client package installs a subset of Microsoft® StreamInsight which lets you implement only the client side functionality: Connecting to an existing StreamInsight server, managing queries, and using the debugger tool. It does not support running an embedded server or creating a StreamInsight service. The installation of the Microsoft® StreamInsight Client does not need a product key.
      Microsoft® StreamInsight has two different methods to complete the installation process:
      • Attended Installation – an interactive user interface will guide you through the set-up process and obtain all of the information and consent required to complete the installation. This includes the displaying, acknowledgement, and archiving of the applicable SQL Server license terms.

      • Unattended Installation – this is a DOS command line set-up process that does not have an interactive user interface to guide you through the set-up process. In this case, you will be required to enter a parameter during installation that indicates your acceptance of the license terms.
  • Supported Operating System

    Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2

      Notes: Windows XP and Windows Server 2003 (x86 and x64) with restrictions: The event tracing feature of the debugging tool is not functional on these versions.

    • Microsoft® StreamInsight is a development platform. The installation makes the SDK available through a set of .NET namespaces. For further information on StreamInsight application development please refer to the resources listed above. .

      Installation instructions for the .msi file:

      1. Download and run StreamInsight.msi.
      2. If you intend to install and use the StreamInsight service, or use the persisted metadata store in your own embedded server, or use the checkpointing feature, you will need SQL Server CE. Install SQL Server CE through the included .msi. StreamInsight requires at least Cumulative Update 4 for Microsoft SQL Server Compact 3.5 Service Pack 2. The SQL Server CE .msi will be put into the redist subfolder of the StreamInsight installation folder (typically C:\Program Files\Microsoft StreamInsight 1.2 x64 (en)\redist).