CodePlex Tool: SQL Server 2008 Extended Events SSMS Addin

Yesterday we discussed traversing the CodePlex tool offerings for SQL Server.  Our first installment is the SQL Server 2008 Extended Events SSMS Addin written by MVP/MCM Jonathan Kehayias (blog|twitter)  of SQLskills.com.

The install was a simple GUI installer and after an SSMS restart, I could see the nice little GUI as seen in the image below.  This is great idea because there is currently not an extended events interface in SQL Server Management Studio. 

Personally, I haven’t worked very much with extended events, but I would like to learn more.  With that being said, I am not sure if the tool works or not because I really do not know what I am looking for.  Does this image mean I have an error?  When I click on the event , it does nothing which leads me to believe that I do not have an error.  I do see where I can edit the event session “system_health” but I am not sure if the items in the list are always there or only there when the event fires?  Jonathan is an MCM and is much smarter than me in regards to SQL Server, so maybe someone else can comment on this tool?  Maybe we can convince Jonathan to create some documentation.  Enjoy!

Extended Events SSMS GUI

Advertisements

About SQLGator

Florida Gator and Microsoft Data Platform MVP, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on June 19, 2012, in Maintenance and tagged , . Bookmark the permalink. 2 Comments.

  1. Hey Ed,

    I actually did write documentation for the Addin that is buried in the releases, but I updated it as a part of the XEvent A Day series:

    http://sqlskills.com/blogs/jonathan/post/An-XEvent-a-Day-(12-of-31)-Using-the-Extended-Events-SSMS-Addin.aspx

    Feel free to ping me if you have any questions after going through that post. I’d be more than happy to answer them for you.

    Cheers!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: