Skip to content

sys-sp-xtp-control-proc-exec-stats-transact-sql.md

Latest commit

 

History

History
74 lines (51 loc) · 2.14 KB

sys-sp-xtp-control-proc-exec-stats-transact-sql.md

File metadata and controls

74 lines (51 loc) · 2.14 KB
title sys.sp_xtp_control_proc_exec_stats (Transact-SQL)
description Enables statistics collection for natively compiled stored procedures for the instance.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sys.sp_xtp_control_proc_exec_stats
sys.sp_xtp_control_proc_exec_stats_TSQL
helpviewer_keywords
sys.sp_xtp_control_proc_exec_stats
dev_langs
TSQL

sys.sp_xtp_control_proc_exec_stats (Transact-SQL)

[!INCLUDE sqlserver]

Enables statistics collection for natively compiled stored procedures for the instance.

To enable statistics collection at the query level for natively compiled stored procedures, see sys.sp_xtp_control_query_exec_stats.

Syntax

sys.sp_xtp_control_proc_exec_stats
    [ [ @new_collection_value = ] collection_value ]
    , [ @old_collection_value = ] old_collection_value OUTPUT
[ ; ]

Arguments

[ @new_collection_value = ] new_collection_value

Determines whether procedure-level statistics collection is on (1) or off (0). @new_collection_value is bit.

@new_collection_value is set to zero when [!INCLUDE ssNoVersion] or the database starts.

[ @old_collection_value = ] old_collection_value

Returns the current status. @old_collection_value is bit.

Return code values

0 for success. Nonzero for failure.

Permissions

Requires membership in the fixed sysadmin role.

Examples

To set @new_collection_value and query for the value of @new_collection_value:

EXECUTE sys.sp_xtp_control_proc_exec_stats @new_collection_value = 1;

DECLARE @c AS BIT;

EXECUTE sys.sp_xtp_control_proc_exec_stats
    @old_collection_value = @c OUTPUT;

SELECT @c AS 'collection status';

Related content