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
- Project that reads events from a previously recorded trace file
- 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.