ManageEngine® SQLDBManager Plus Replication 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. |
Database Details |
Jobs and Backup |