Sdílet prostřednictvím


Subscription, Undistributed Commands (Transactional Subscription, SQL Server 2005 and Later)

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).

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 Reinitializing a Subscription.