Search code examples
sql-server-2008complex-event-processingstreaminsight

Microsoft's StreamInsight - Experiences & SQL Server 2008 R2


Microsoft's Complex Event Processing (CEP) offering StreamInsight was released in tandem with SQL Server 2008 R2.

I am wondering:

  • if StreamInsight is in any way tied to the SQL Server 2008 R2 database and if it can be run separately.

    (From scanning over the documentation it looks like StreamInsight can be
    run separately but clarification would be desirable).

  • If you have experience using StreamInsight separate from SQL Server 2008 R2 how has the experience been?

Thanks!


Solution

  • "As for your thoughts regarding StreamInsight (SI) and SQL Server 2008 R2; at least at this moment, SI has no dependencies on SQL Server 2008 R2 what so ever. For certain operations you may need a SQL Server Compact (CE) db, which stores metadata – but you can definitely use SI against other databases than SQL if you so wish." Niels of http://www.sqldevelop.com/