| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sp_help_change_feed_settings (Transact-SQL) |
The sys.sp_help_change_feed_settings system stored procedure returns state information for Microsoft Fabric Mirroring. |
WilliamDAssafMSFT |
wiassaf |
imotiwala |
03/11/2024 |
fabric |
system-objects |
reference |
|
|
|
>=sql-server-ver16||=azuresqldb-current||=fabric||=azure-sqldw-latest |
[!INCLUDE asdb-fabric]
Provides the provision or deprovision status and information of the Fabric Mirrored Database feature.
This system stored procedure is used 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).
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
EXECUTE sys.sp_help_change_feed_settings;
None
| Column name | Data type | Description |
|---|---|---|
maxtrans |
int | Maximum transactions to process in each cycle. The default is 10000. |
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 remains in this state until complete. |
A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.
If Fabric Mirroring, the source SQL database transaction log is monitored. If the transaction log is observed to be full and the log reuse reason is REPLICATION, the database will automatically be reinitialized to Fabric to allow the transaction log to be truncated. During this special reseed state, a database snapshot is sent to Fabric again, then incremental replication resumes. The reseed_state column in sys.sp_help_change_feed_settings indicates the reseed state.
- 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_change_feed_configure_parameters (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: