managed-backup-fn-get-current-xevent-settings-transact-sql.md

title	managed_backup.fn_get_current_xevent_settings (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	fn_get_current_xevent_settings smart_admin.fn_get_current_xevent_settings_TSQL fn_get_current_xevent_settings_TSQL smart_admin.fn_get_current_xevent_settings
dev_langs	TSQL
helpviewer_keywords	smart_admin.fn_get_current_xevent_settings fn_get_current_xevent_settings
ms.assetid	95d3adaa-bb9d-4833-b8b4-3d9fd4f9c82a
author	MikeRayMSFT
ms.author	mikeray

managed_backup.fn_get_current_xevent_settings (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx-md]

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.

Transact-SQL Syntax Conventions

Syntax

smart_admin.fn_get_current_xevent_settings ()   

Arguments

This function does not have any arguments.

Table Returned

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

Column Name	Data Type	Description
Event_name	NVARCHAR(128)	Extended Event type
is_configurable	NVARCHAR(128)	This is set to True if the event is configurable, else it set to False.
is_enabled	NVARCHAR(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.

Security

Permissions

Requires SELECT permissions on the function.

Examples

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

SELECT *   
FROM smart_admin.fn_get_current_xevent_settings ()