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
Duartion (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