SQL Profiler Through StreamInsight Sample Solution

by Allan Mitchell 23 Aug 2010 23:35

In this postI show how you can use StreamInsight to take events coming from SQL Server Profiler in real-time and do some analytics whilst the data is in flight.  Here is the solution for that post.  The download contains

  1. Project that reads events from a previously recorded trace file
  2. Project that starts a trace and captures events in real-time from a custom trace definition file (Included)

It is a very simple solution and could be extended.  Whilst this example traces against SQL Server it would be trivial to change this so it profiles events in Analysis Services.

 

 

 

Enjoy.

Comments are closed

Widget Amazon Book not found.

Object reference not set to an instance of an object.X