sys.sp_change_feed_configure_parameters (Transact-SQL)
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:
- The Azure Synapse Link feature for SQL Server instances and Azure SQL Database. For more information, see Manage Azure Synapse Link for SQL Server and Azure SQL Database.
- The Fabric Mirrored Database feature for Azure SQL Database. For more information, see Microsoft Fabric mirrored databases (Preview).
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. Default value if not specified is 10000
. If specified, the value must be a positive integer.
[ @pollinterval = ] polling_interval
Data type is int. Describes the frequency that the log is scanned for any new changes, in seconds. Default interval if not specified is 5 seconds. The value must be 5
or larger.
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
- sys.sp_help_change_feed (Transact-SQL)
- sys.sp_help_change_feed_table (Transact-SQL)
- sys.sp_help_change_feed_table_groups (Transact-SQL)
- sys.sp_help_change_feed_settings (Transact-SQL)
- sys.dm_change_feed_log_scan_sessions (Transact-SQL)
- sys.dm_change_feed_errors (Transact-SQL)
For Microsoft Fabric mirrored databases:
- Microsoft Fabric mirrored databases (Preview)
- Microsoft Fabric mirrored databases monitoring
- Explore data in your Mirrored database using Microsoft Fabric
For Azure Synapse Link:
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for