ManageEngine® SQLDBManager Plus


Replication Details

<< Prev

Home

Next >>

 

SQL Server - Replications Monitor Details

 

SQLDBManagerPlus provides the option to monitor the replications running on the SQL server monitors. You can monitor the status of publications, subscriptions and replication agent details.

 

Publications

This table displays status information for all publications available in the corresponding SQL monitor.

Parameters

Description

Status

The status of each publication.

Publication

Name of the publication

Type

Type of the publication

No. of Subscriptions

Number of subscriptions associated with the corresponding publication.

Synchronizing

The number of distribution agents running for the publication.

Current Average Performance

Current average performance of the replication based on the latency.

Current Worst Performance

Current worst performance of the replication based on the latency.

Subscriptions

SQLDBManagerPlus provides information about subscriptions available in the corresponding monitor.

Parameters

Description

Running status

Status of each subscription.

Subscription

Name of the subscription

Publication

Name of the publication running the corresponding subscription.

Performance

Performance of the subscription.

Latency

Latency value

Expiration Status

Shows expiring status of the subscription which can be one of the following

  • Expired
  • Expiring soon
  • Critical

Replication Agents

Replication Agents tab displays information about each replication agent running in the corresponding monitor.

Parameters

Description

Agent Name

Name of the agent involved in the replication

Agent Type

Type of the agent

Current Status

Current status of the agent

[Database].[Publication]

Name of the publisher

Last Start Time

Last start time of the agent

Duration (HH:mm:ss)

Duration of the agent session.

Delivary Rate (cmds/sec)

Ratio of delivered commands to the duration of the agent.

Latency

The current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the distributor.

#Trans

The number of transactions delivered to the distributor.

#Cmds

The number of commands delivered to the distributor.

Avg #Cmds

The average number of commands per transaction delivered to the distributor for the session.

Replication Agent History Table

Displays the performance metrics of various agents history running in SQL server. You will be able to view replication agent's history when you click on the corresponding agent from Agent Details table. This will show the step by step agent execution history for that corresponding agent in a pop-up window.

Parameters

Description

Current status

Current status of the agent

Last start time

Last start time of the agent

Duration (HH:mm:ss)

Duration of the agent session.

Last Action

Displays the last action message of the agent.

<< Prev

Home

Next >>

Database Details

Jobs and Backup