Edit

Share via

sys.sp_xtp_control_proc_exec_stats (Transact-SQL)

  • Article

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.

Syntax

syntaxsql 
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:

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

Related content