Publisher Information, Publications

The Publications tab provides summary information for all publications at the Publisher selected in the left pane.

Options

Status
The status of each publication, which is determined by the highest priority status of its subscriptions. By default, the grid containing publication information is sorted by the Status column. 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
- Retrying failed command
- OK
The status value Performance critical is relevant for transactional subscriptions and merge subscriptions; for transactional subscriptions, it can be displayed only if a threshold is set. For information on performance measurements and setting thresholds, see Monitoring Performance with Replication Monitor and Setting Thresholds and Warnings in Replication Monitor.

Publication
The name of each publication, in the form PublicationDatabaseName: PublicationName.

Synchronizing
The number of subscriptions for each publication that are currently synchronizing:
- For transactional replication, "synchronizing" means that the Distribution Agent is running, but data is not necessarily being replicated.
- For merge replication, "synchronizing" means that the Merge Agent is running and that data is currently being replicated.
- For snapshot replication, "synchronizing" means that the Distribution Agent is running and that data is currently being replicated.

Current Average Performance and Current Worst Performance
Microsoft SQL Server 2005 and later versions only. The average performance rating and the worst performance rating, respectively, for all subscriptions to a publication. Ratings are based on the most recent measurements taken by Replication Monitor and do not reflect the performance of a subscription over time.

For transactional replication, Replication Monitor displays a value only for publications that have performance thresholds defined. If performance thresholds are not defined for a publication, this column displays Not enabled. For merge replication, Replication Monitor displays a value after five synchronizations have occurred with 50 or more changes each over the same type of connection (dial-up or LAN). If there have been less than five synchronizations with 50 or more changes or the most recent synchronization has less than 50 changes, this column is blank.

The performance rating is one of the following values:
- Excellent
- Good
- Fair
- Poor
- Critical
For more information about how performance ratings are defined and how performance thresholds are set, see Monitoring Performance with Replication Monitor.