|
Note: Connections to SQL Server Replication is available for SQL Server 2005 and later. |
Drilldown on current and recent activity details for the replication environment.
To see the SQL Activity drilldown
Click Monitor | Activity.
To investigate... | Look at the... | |
---|---|---|
Publications | Publications page |
Shows information about the publications on the publisher. |
Subscriptions | Subscriptions page |
Shows information about the subscriptions that belong to a publication on the publisher. Shows the delivery rate for the selected subscription between the publisher and distributor, and the distributor and subscriber. A high number of undistributed commands may indicate latency issues on the distributor. The buttons and flows show current alarms for the subscription selected in the grid above. Shows information about the Log Reader Agent session for the subscription selected in the Subscriptions grid above. Shows detailed information about the sessions on the Merge Agent. Shows article statistics for the selected session on the Merge Agent. Shows information about the Distribution Agent session for the subscription selected in the Subscriptions grid above. Shows the informational and error messages logged for the selected session. |
Agents | Agents page |
Shows information about agent sessions. Shows various statistics relating to agent sessions. The following counters can be displayed by clicking the arrow next to the chart name: Delivery Rate - Average number of commands delivered per second. Delivery Latency - Latency, in milliseconds, between the transaction entering the distribution database and being applied to the Subscriber. Delivered Transactions - Total number of transactions delivered in the session. Delivered Commands - Total number of commands delivered in the session. Average Commands - Average number of commands per transaction delivered in the session. Shows information about the sessions on the selected agent. Shows the informational and error messages logged for the selected session. |
|
TIP: For more information on Spotlight charts and grids see Spotlight charts and Spotlight grids |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy