Edit

Share via

sys.sp_change_feed_configure_parameters (Transact-SQL)

  • Article

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure Synapse Analytics Microsoft Fabric

Used to reduce latency by decreasing change batch size with @maxtrans, or to reduce the cost by increasing the batch size. As the batch size increases, less IO operation will be performed.

This system stored procedure is used to fine tune the operational performance for:

Syntax

Transact-SQL syntax conventions

sys.sp_change_feed_configure_parameters
    [ [ @maxtrans = ] max_trans ]
    [ , [ @pollinterval = ] polling_interval ]
[ ; ]

Arguments

[ @maxtrans = ] max_trans

Data type is int. Indicates the maximum number of transactions to process in each scan cycle.

  • For Azure Synapse Link, the default value if not specified is 10000. If specified, the value must be a positive integer.
  • For Fabric mirroring, this value is dynamically determined and automatically set.

[ @pollinterval = ] polling_interval

Data type is int. Describes the frequency that the log is scanned for any new changes, in seconds.

  • For Azure Synapse Link, the default interval if not specified is 5 seconds. The value must be 5 or larger.
  • For Fabric mirroring, this value is dynamically determined and automatically set.

Returns

0 (success) or 1 (failure).

Permissions

A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.

Related content

For Microsoft Fabric mirrored databases:

For Azure Synapse Link: