Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
Applies to: SQL Server (SQL Server 2014 through current version).
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.
Extended Event type
This is set to True if the event is configurable, else it set to False.
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.