Extended events

As with all new features inside SQL Server, In-Memory OLTP also provides Extended Events session details. There is an extensive set of events that can be captured by Extended Events. Using the Extended Events Wizard will allow you to easily choose which events you wish to collect. Extended Events is the preferred method for collecting internal system information on any feature of SQL Server (where possible). Extended Events is a lightweight collection framework that allows you to collect system runtime statistics while keeping resource usage to a minimum.

A T-SQL query to return a list of the Extended Events that are available for the In-Memory OLTP engine would be:

SELECT p.name, 
    o.name, 
    o.description 
FROM sys.dm_xe_objects o 
    JOIN sys.dm_xe_packages p 
        ON o.package_guid = p.guid 
WHERE p.name = 'XtpEngine'; 
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.129.210.91