Edit

Subscription, Undistributed Commands (Transactional Subscription)

  • Article

Applies to: SQL Server Azure SQL Database

The Undistributed Commands tab displays information about the number of commands in the distribution database that have not been delivered to the selected Subscriber, and the estimated time to deliver those commands. For information about viewing the commands in the distribution database, see sp_replshowcmds (Transact-SQL).

Note

Azure SQL Managed Instance can be a publisher, distributor, and subscriber for snapshot and transactional replication. Databases in Azure SQL Database can only be push subscribers for snapshot and transactional replication. For more information, see Transactional replication with Azure SQL Database and Azure SQL Managed Instance.

Options

Number of commands in the distribution database waiting to be applied to this Subscriber
The number of commands in the distribution database that have not been delivered to the selected Subscriber. A command consists of one Transact-SQL data manipulation language (DML) statement or one data definition language (DDL) statement.

Estimated time to apply these commands, based on past performance
The estimated amount of time to deliver commands to the Subscriber. If this value is greater than the amount of time required to generate and apply a snapshot to the Subscriber, consider reinitializing the Subscriber. For more information, see Reinitialize Subscriptions.

See Also

Start the Replication Monitor
Monitor Performance with Replication Monitor
Monitoring Replication