Light Weight Monitoring using Extended Events

10. Finally, make sure you stop the Session.

ALTER EVENT SESSION xe_event_page_split ON SERVER STATE = stop;

User Interface Support

There is no native interface to support Extended Events. However, there is an add-in available in Codeplex called Extended Events Manager. After installing this, there will be an add-in in the SQL Server Management Studio which allows you to perform all the operations in the GUI.

There is an option in Extended Events Manager  to view all the Extended Data metadata in a tree view:

Similarly, you can create sessions and start them immediately:

I have created few extended events samples which you can download from my skydrive, http://cid-22a79fce82651673.skydrive.live.com/browse.aspx/Articles/Extented%20Events

References:

http://msdn.microsoft.com/en-us/library/dd822788.aspx

http://msmvps.com/blogs/eladio_rincon/archive/2008/12/07/using-xevents-extended-events-in-sql-server-2008-to-detect-which-queries-are-causing-page-splits.aspx

http://msdn.microsoft.com/en-us/library/dd822788.aspx

http://msdn.microsoft.com/en-us/library/ee412262.aspx

http://www.sqlskills.com/BLOGS/BOBB/post/More-about-XEvent-actions-and-targets-(still-raining-still-dreaming).aspx

http://www.sqlskills.com/BLOGS/BOBB/category/Extended-Events.aspx#p8

http://www.sqlteam.com/article/introduction-to-sql-server-2008-extended-events

http://www.sqlteam.com/article/advanced-sql-server-2008-extended-events-with-examples