SQL Server - Getting started with Extended events

This article is about SQL Server Extended events . In this article , I have provided MSDN links which will provide complete & accurate information about each topics related to Extended events .

SQL Server Extended Events (Extended Events)

                                  is a general event-handling system for server systems.


Introducing SQL Server Extended Events

Overview on Extended Events :


We can manage  & control Extended events in SQL Server using T-SQL ,
also we have GUI option  - > Under Object Explorer - >  Management - >  Extended Events



Extended Events

Extended Events Tools

SQL Server Extended Events Sessions

SQL Server Extended Events Packages

A package can contain any or all of the following objects :
    Events ,
    Targets ,
    Actions ,
    Types ,
    Predicates ,
    Maps .

We can get to know about each of the above mentioned objects and their categories from the description column of below queries :


SELECT * FROM sys.dm_xe_objects WHERE object_type = 'type'
SELECT * FROM sys.dm_xe_objects WHERE object_type = 'target'
SELECT * FROM sys.dm_xe_objects WHERE object_type = 'event'
SELECT * FROM sys.dm_xe_objects WHERE object_type = 'action'
SELECT * FROM sys.dm_xe_objects WHERE object_type = 'pred_source'
SELECT * FROM sys.dm_xe_objects WHERE object_type = 'map'
SELECT * FROM sys.dm_xe_objects WHERE object_type = 'message'


sys.dm_xe_objects  - http://technet.microsoft.com/en-us/library/bb677276.aspx

MSDN blogs about Extended events
Using SQL Server 2008 Extended Events by Jonathan Kehayias

See Also :



No comments: