SQL SERVER – StreamInsight and SQL Server 2008 R2

I was recently called into creating POC (Proof of Concept) for a project which was being planned for use StreamInsight. When I was there, I was also asked to give an overview of the this feature to their CTO (who had only 15 minutes to spare). Usually I do not like sudden change of plans, but the dynamic nature of consultation always gives me motivation to work more. I quickly talked few things in the session. In the evening, I had received the minutes of the meeting and had brief note regarding my discussion on StreamInsight. I am copy pasting the same brief note over here.

SQL SERVER - StreamInsight and SQL Server 2008 R2 StreamInsight-Queries

  • StreamInsight is a platform for development and deployment of Complex Event Processing (CEP) applications
  • CEP involves processing and querying of the event data stream
  • The data is queried “on the fly” or rather “in flight”
  • CEP is mainly for high data rates and near-zero latency
  • CEPdeals with multiple concurrent event sources
  • CEP trigger immediate response actions to the events
  • CEP is not targeted to the regular run of the mill relational database applications
  • StreamInsight has very high -throughput stream processing .NET based development and processing architecture
  • StreamInsight is a highly parallel execution platform with in-memory caches
  • The “In flight” processes are done using incremental result computations
  • Due to incoming events triggers there is no polling overhead
  • The architecture can handle out-of-order events
  • StreamInsightserver hides complexity for developers who wants to focus on query logic only
  • In Short StreamInsight is the way to go to query data which arrives too fast to the store.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Server
Previous Post
SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh
Next Post
SQL SERVER – System Stored Procedure sys.sp_tables

Related Posts

Leave a Reply