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




Array

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 |