| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sp_change_feed_configure_parameters (Transact-SQL) |
The sys.sp_change_feed_configure_parameters system stored procedure is used to increase the batch size with higher transactions. |
WilliamDAssafMSFT |
wiassaf |
imotiwala |
06/03/2024 |
fabric |
system-objects |
reference |
|
|
|
>=sql-server-ver16 || =azuresqldb-current || =fabric || =azure-sqldw-latest |
[!INCLUDE sqlserver2022-asdb-asa-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 What is Mirroring in Fabric?
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sys.sp_change_feed_configure_parameters
[ [ @maxtrans = ] max_trans ]
[ , [ @pollinterval = ] polling_interval ]
[ ; ]
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.
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
5or larger. - For Fabric mirroring, this value is dynamically determined and automatically set.
0 (success) or 1 (failure).
A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.
- 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:
- What is Mirroring in Fabric?
- Monitor Fabric mirrored database replication
- Explore data in your Mirrored database using Microsoft Fabric
For Azure Synapse Link: