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
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 :
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
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
No comments:
Post a Comment