Publication Information, All Subscriptions (Transactional Publication)

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The All Subscriptions tab displays information on all subscriptions to the selected transactional publication.


For more detailed information and tasks related to a subscription, right-click the row for that subscription, and then click an option on the shortcut menu. To change the way that the grid displays data, right-click the grid, and then click one of the following options:

  • Sort: Sort on one or more columns in the Sort Columns dialog box.

  • Choose Columns to Show: Select which columns to display and the order in which to display them in the Choose Columns dialog box.

  • Filter: Filter rows in the grid based on column values in the Filter Settings dialog box.

  • Clear Filter: Clear any filter settings for the grid.

    Filter settings are specific to each grid. Column selection and sorting are applied to all grids of the same type, such as the publications grid for each Publisher.

    Microsoft SQL Server 2005 and later versions only. Select the subscription states to display for the selected subscription type. For example, you can select to display only those subscriptions that have an error.

    The status of each subscription, which is determined by the status of the Distribution Agent or the Log Reader Agent (the higher priority status is displayed; the status can also be determined by the Queue Reader Agent if queued updating subscriptions are used).

    By default, the grid containing subscription information is sorted by the Status column (and then sorted by the Performance column for those subscriptions with the same status). The following list shows the possible status values and the sort order for the values (for example, errors are always shown at the top of the grid).

  • Error

  • Performance critical ( SQL Server 2005 and later versions only)

  • Expiring soon/Expired ( SQL Server 2005 and later versions only)

  • Uninitialized subscription ( SQL Server 2005 and later versions only)

  • Retrying failed command

  • Not Running

  • Running

    The sort order also determines which value is displayed if a given subscription is in more than one state. For example, if a subscription has an error and is expiring soon, the Status column displays Error.

    The status values Performance critical, Expiring soon/Expired, and Uninitialized subscription are warnings. When a warning is displayed, the Status column also displays if an agent is running. For example, the status could be Running, Performance critical.

    The status values Performance critical and Expiring soon/Expired are displayed only if thresholds are set. For information on performance measurements and setting thresholds, see Monitor Performance with Replication Monitor and Set Thresholds and Warnings in Replication Monitor.

    The name of each subscription, in the form: SubscriberName: SubscriptionDatabaseName.

    SQL Server 2005 and later versions only. The performance rating for each subscription is based on the most recent measurements taken by Replication Monitor and does not reflect historical performance. Performance is measured for subscriptions to publications that have performance thresholds defined; if performance thresholds are not defined for a publication, this column displays Not enabled. The performance rating is one of the following values:

  • Excellent

  • Good

  • Fair

  • Poor

  • Critical

    If performance is critical, Performance Critical is displayed in the Status column. For more information on how performance ratings are defined and how performance thresholds are set, see Monitor Performance with Replication Monitor.

    SQL Server 2005 and later versions only. The average amount of time that elapses between a transaction being committed at the Publisher and the corresponding transaction being committed at the Subscriber. The latency displayed is based on the most recent measurements taken by Replication Monitor. For more information about measuring latency, see Measure Latency and Validate Connections for Transactional Replication.

See Also

Start the Replication Monitor
View Information and Perform Tasks for a Subscription (Replication Monitor)
View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor)
Monitoring Replication