sys.sp_xtp_control_proc_exec_stats (Transact-SQL)
Applies to:
SQL Server
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).
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 SQL Server 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:
EXEC sys.sp_xtp_control_proc_exec_stats @new_collection_value = 1;
DECLARE @c BIT;
EXEC sys.sp_xtp_control_proc_exec_stats @old_collection_value = @c OUTPUT;
SELECT @c AS 'collection status';