Microsoft® SQL Server® StreamInsight 2.1

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.

Microsoft StreamInsight 2.1 introduces a new object model that is more clear and consistent than in earlier versions, eliminating the need for complex input and output adapters. This new model allows you to provision, name, and manage data sources and sinks in the StreamInsight server, and you can checkpoint over temporal streams and across multiple processes. Moreover, this version of StreamInsight allows to tightly integrate reactive (Rx) and temporal queries within the same hosting model.

A SQL Server 2012 license is required to install the full Microsoft StreamInsight 2.1 package.

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.

A product key is not required to install the Microsoft® StreamInsight Client.
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 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 Systems

Windows 7, Windows 8 Consumer Preview, Windows Server 2008 R2 SP1, 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.

Other Requirements:

• This component also requires Microsoft .NET Framework 4.0.
• The full StreamInsight installation package requires a SQL Server 2012 license (an instance of SQL Server does not need to be installed).

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 2.1 x64 (en)\redist).