TechNet
Export (0) Print
Expand All

managed_backup.fn_get_current_xevent_settings (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns 1 row for each Extended Event type supported by Smart Admn.

Use this function to return or review the current Extended Event settings to identify the type of events that are configurable and the current configurations.

Topic link icon Transact-SQL Syntax Conventions

smart_admin.fn_get_current_xevent_settings ()   

This function does not have any arguments.

Admin, analytic, and operational channels of the Extended Events are necessary are enabled by default and not configurable.

Column NameData TypeDescription
Event_nameNVARCHAR(128)Extended Event type
is_configurableNVARCHAR(128)This is set to True if the event is configurable, else it set to False.
is_enabledNVARCHAR(128)This is set to True if the event is enabled, set to False if it is not enabled. Use the smart_admin.sp_set_parameter to enable debug events.

Permissions

Requires SELECT permissions on the function.

The following example returns all the Extended Events with their current status.

SELECT *   
FROM smart_admin.fn_get_current_xevent_settings ()  
  

Community Additions

ADD
Show:
© 2016 Microsoft