Edit

Share via

sys.sp_help_change_feed_settings (Transact-SQL)

Applies to: SQL Server 2022 (16.x) and later versions Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Preview

Provides the status and configuration of the Fabric Mirrored Database change feed feature. Changes to change feed settings are made with sys.sp_change_feed_configure_parameters (Transact-SQL).

This system stored procedure is used for:

Syntax

Transact-SQL syntax conventions

EXECUTE sys.sp_help_change_feed_settings;

Arguments

None.

Result set

Column name Data type Description
maxtrans int Maximum transactions to process in each cycle. The default is 10,000.
seqno binary(10) Log Sequence Number (LSN) marker to track the last published LSN (log record).
schema_version int Tracks current schema version of database. Determines whether a schema needs to be updated or not on startup.
pollinterval int The frequency that the log is scanned for any new changes in seconds.
reseed_state tinyint Applies to: Fabric Mirrored Database only.

0 = Normal.

1 = The database has started the process of reinitializing to Fabric. Transitionary state.

2 = The database is being reinitialized to Fabric and waiting for replication to restart. Transitionary state. When replication is established, reseed state moves to 0.
destination_type sysname Change event streaming destination type.

AzureEventHubsAmqp
AzureEventHubsKafka

Introduced in SQL Server 2025 (17.x) Preview
partition_scheme tinyint Change event streaming partition scheme.

0 = None
1 = Table group.
2 = Table
3 = Column

Introduced in SQL Server 2025 (17.x) Preview
encoding tinyint Change event streaming message encoding.

0 = JSON
1 = Avro Binary

Introduced in SQL Server 2025 (17.x) Preview
autoreseed tinyint Whether or not automatic reseeding is enabled for the current database in Fabric Mirroring.

0 = Disabled
1 = Enabled

The autoreseed feature is disabled by default in SQL Server 2025 (Preview). The autoreseed feature is enabled and cannot be managed or disabled in Azure SQL Database and Azure SQL Managed Instance. For more information, see Configure automatic reseed for Fabric mirrored databases from SQL Server.
autoreseedthreshold tinyint If autoreseed is enabled, the transactions log usage percentage at which to trigger automatic reseed. The default is 70. For SQL Server 2025 (Preview), this must be configured when autoreseed is enabled.
dynamicmaxtrans int Whether or not the dynamic maximum transactions setting is enabled. The dynamic maximum transactions feature is enabled by default in SQL Server 2025 (Preview). The dynamic maximum transactions feature is enabled and cannot be managed or disabled in Azure SQL Database and Azure SQL Managed Instance. Fabric mirroring always follows a maximum number of transactions to process in each scan cycle as defined by the maxtrans setting. When dynamicmaxtrans = 1, Fabric mirroring dynamically adjusts the number of transactions to process per scan between configured values for dynamicmaxtranslowerbound and maxtrans. For more information, Mirrored databases from SQL Server performance.
dynamicmaxtranslowerbound int The lower bound for dynamic maxtrans setting for Fabric Mirroring. By default, the lower bound value is 200 but can be modified by sys.sp_change_feed_configure_parameters (Transact-SQL).

Permissions

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

Related content