SQL Profiler Through StreamInsight Sample Solution

Posted on SQLIS See other posts from SQLIS
Published on Mon, 23 Aug 2010 23:35:36 +0100 Indexed on 2010/12/06 16:59 UTC
Read the original article Hit count: 242

Filed under:

Code Development

|

Presentations

|

StreamInsight

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.

Enjoy.

© SQLIS or respective owner

Related posts about Code Development

Soapi.CS : A fully relational fluent .NET Stack Exchange API client library

as seen on Stackapps - Search for 'Stackapps'
Soapi.CS for .Net / Silverlight / Windows Phone 7 / Mono as easy as breathing...: var context = new ApiContext(apiKey).Initialize(false); Question thisPost = context.Official .StackApps .Questions.ById(386) .WithComments(true) .First(); Console.WriteLine(thisPost.Title); thisPost … >>> More
Super Joybox 5 HID 0925:8884 not recognized as joystick in Ubuntu 12.04 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Problem: When using the "Super JoyBox 5" 4 port playstation 2 to USB adapter, the device is not recognized as a joystick. there is no js0 created, but instead another input eventX and mouseX are created in /dev/input. When using the directional buttons (up down left right) on a Playstation 1 controller… >>> More
How to resolve: 'cmd' is not recognized as an internal or external command?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have searched other forums to solve this error where it would either end with: 1.) re-install OS 2.) Setting path variable C:/Windows/System32 The latter did not work, and as you can probably imagine, I do not want to have to re-install my OS... I am running the command "mvn jetty:run" and the… >>> More
Small Business Web Site Development - 3 Tips For Getting Business Web Development

as seen on Ezine Articles - Search for 'Ezine Articles'
If your want to grow your Small Business, Web Site Development is a crucial ingredient for this new growth going forward. Web development is more than putting words or content on a web page. Today more than 50% of folks looking for products or services use the internet to find what they needs. Here… >>> More
Surface development: it’s just like software development

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Surface is magic. Everyone using it seems to think that way. And I have to be honest, after working for almost 2 years with the platform I still get that special feeling the moment I turn on the unit to do some more work. The whole user experience, the rich environment of the SDK, the touch, even… >>> More

Related posts about Presentations

How to create animated presentations/video-presentations?

as seen on Super User - Search for 'Super User'
Making presentation using PowerPoint is kind of too simple, it's possible to make nice presentations but I would like do a step forward. I'm wondering how people make animations like this one: http://www.facebook.com/video/video.php?v=10150210521510484 ? >>> More
Change Data Capture Webinar

as seen on SQLIS - Search for 'SQLIS'
I am going to be doing a webinar with our friends at Attunity on Change Data Capture. Attunity have a good story around this technology and you can use it in your SSIS loads to great effect. Join Attunity and Konesans/SQLIS for a Webinar on 17 September Space is limited. Reserve your… >>> More
Manchester UG Presentation Video

as seen on SQLIS - Search for 'SQLIS'
In July I was invited to speak at the UK SQL Server UG event in Manchester. I spoke about Excel being a good data mining client. I was a little rushed at the end as Chris Testa-ONeill told me I had only 5 minutes to go when I had only been talking for 10 minutes. Apparently I have… >>> More
Change Data Capture Webinar

as seen on SQLIS - Search for 'SQLIS'
I am going to be doing a webinar with our friends at Attunity on Change Data Capture. Attunity have a good story around this technology and you can use it in your SSIS loads to great effect. Join Attunity and Konesans/SQLIS for a Webinar on 17 September Space is limited. Reserve your… >>> More
Learn Lean Software Development and Kanban Systems

as seen on Johnny Coder - Search for 'Johnny Coder'
I did an in-house presentation on Lean Software Development (LSD) and Kanban Systems this week. Beyond what I had previously learned from various podcasts, I knew little about either topic prior to compiling my slide deck. In the process of building my presentation, I learned a ton. I found the… >>> More