Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

SQL Server Replication | Home Page

Note: Connections to SQL Server Replication is available for SQL Server 2005 and later.

The Spotlight Home Page provides a unique view of the activity of the replication environment. The Spotlight Home Page highlights obvious bottlenecks and problem areas. Statistics and flows are updated in real time. For more information on Spotlight home pages, see Spotlight home page

To see the Spotlight Home Page

  1. Select a SQL Server Replication environment from Monitored connections.
  2. Click Monitor | Home.

Overview of the components in a replication environment

Microsoft uses a publishing metaphor to describe its SQL Server Replication model. In this model, the servers and processes involved in replication can be likened to the roles within a publishing environment.

The table below briefly describes each of the components in a replication environment.

Component Description

Publisher

Makes data available for subscription to other servers within the replication environment.

Distributor

Hosts the distribution database. The Distributor can be local or remote to a Publisher.

Subscriber

Receive the replicated data.

Publication

A collection of one or more articles from a database.

Article

A table or partition of data, or a database object, specified for replication.

Subscription

A request made by either a Publisher or Subscriber for a copy of data.

Agents

Replication processes responsible for managing, copying, and moving data between publishers and subscribers. Examples of agents include:

  • Distribution agent
  • Snapshot agent
  • Log Reader agent
  • Merge agent
  • Queue Reader agent
  • Miscellaneous agents
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating