SQL Server 2008 R2 introduces StreamInsight, a comprehensive development platform for building event-driven applications. While typical relational database applications are query-driven, event-driven applications are characterized by high event data rates, continuous standing queries, and millisecond latency requirements that make it impractical to store the data in a relational database for processing. Event driven application workloads are common in many different industries, including manufacturing, oil and gas, utilities, financial services, health care, retail, web analytics and data center monitoring. Developers turn to complex event processing (CEP) technology like StreamInsight to query, monitor and identify patterns and relationships from huge volumes of seemingly unrelated events, then trigger response actions when specific conditions are met.
For more information, check out this course on Microsoft Virtual Academy: