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!
From posting the same query on my blog I got a response in the comments confirming what I suspected:
"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/
my experience with streaminsight has been in a POC we've made here. this product is not mature enough in my opinion to be a production infrastructure.