sys.sp_xtp_control_proc_exec_stats (Transact-SQL)

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

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 (Transact-SQL).


sp_xtp_control_proc_exec_stats [ [ @new_collection_value = ] collection_value ], [ @old_collection_value]  


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

@new_collection_value is set to zero when SQL Server or the database starts.

@old_collection_value = value
Returns the current status.

Return Code

0 for success. Nonzero for failure.


Requires membership in the fixed sysadmin role.

Code Samples

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

exec [sys].[sp_xtp_control_proc_exec_stats] @new_collection_value = 1  
declare @c bit  
exec sp_xtp_control_proc_exec_stats @old_collection_value=@c output  
select @c as 'collection status'  

See Also

System Stored Procedures (Transact-SQL)
In-Memory OLTP (In-Memory Optimization)