sys.sp_xtp_control_proc_exec_stats

Description

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 Determines whether procedure-level statistics collection is on ( @new_collection_value is set to zero when SQL Server or the database starts. for success. Nonzero for failure.

Syntax

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

Permissions

06/23/2025 To enable statistics collection at the query level for natively compiled stored procedures, see sys.sp_xtp_control_query_exec_stats. syntaxsql Determines whether procedure-level statistics collection is on ( ) or off ( ). @new_collection_value is. @new_collection_value is set to zero when SQL Server or the database starts. Returns the current status. @old_collection_value is. for success. Nonzero for failure.

Examples

Example 1

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'
;