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

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |