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

Script Name	Events	Target	Comment
Xe.sql			This script contain basic queries needed for extended events
xe_page_split.	page_split	asynchronous_file_target	Identify page splits
XE_sql_server_errors	error_reported	ring_buffer	Capture SQL Server errors
xe_paring_transaction	database_transaction_begin database_transaction_end	pair_matching	Capture uncommitted or unroll back transactions
xe_locking_information	lock_acquired lock_released	asynchronous_file_target	Capture locking information on SQL Server objects

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

]]>