Database Reference
In-Depth Information
SQL Server 2008 R2 has a new feature, StreamInsight. StreamInsight is a powerful platform
that enables the processing of high-speed data streams from multiple data sources.
The technology is useful for financial applications such as stock exchanges, banks for
fraud detection, retail applications such as ISPs for surveillance of internet traffic, and
manufacturing for real-time business intelligence. The StreamInsight Standard edition is
available in SQL Server 2008 R2 Standard, or Enterprise, or Web editions, and StreamInsight
Premium edition in SQL Server 2008 R2 Datacenter, or Developer, or Evaluation editions.
However, the premium version of StreamInsight is recommended only when event rates
exceed 5000 events per second or latency requirements are less than 5 seconds. For event
rates less than 5000 events per second and/or latency requirements in excess of 5 seconds,
the standard version of StreamInsight is recommended.
StreamInsight is built to detect, decide, and respond. Event processing is the main component
to monitor a system or process by looking for exceptional behavior and generating alerts when
such behavior exceeds the business process levels. The reaction is generated in the form of
alerts; for real-time applications it requires a recovery action—automated or manually. The
event processing component keeps the logic that processes the events separate from the
event producers and consumers. These actions can be divided into:
F
Deterministic: In this approach, there is an exact mapping between a situation in the
real world and its representation in the event processing system
F
Approximate: Here, the event processing system provides an approximation to
real-world events
StreamInsight extends the advantage and effectiveness of event processing, which can reduce
the substantial cost of ownership of an event processing application. The cost reduction is
visible from the level of abstraction, which is similar to the relational database management
system to hold data rather than using a filesystem component. The internals of event
processing provide the abstractions for handling events that are higher than conventional
programming languages; this is where the reduction in the cost of development and
maintenance is visible.
In this recipe, we will look at how to implement StreamInsight onto your existing SQL Server
2008 R2 platform.
Getting ready
Like all other Microsoft products, the StreamInsight client package installs a subset of
feature technology, which implements only the client-side functionality. The package installs
the components in connecting to an existing StreamInsight server to manage queries and
the debugger tool. For the SQL Server 2008 R2 RTM release, StreamInsight client does not
require a license, but for server side the license needs to be part of SQL Server license, which
is documented in End-User License Agreemen
t (EULA), see
http://www.microsoft.
1ca87b701c2f&
displaylang=en
.
Search WWH ::
Custom Search