Diagnostic tools retrieve the status and statistics of Replication Server components which, depending on the type of problem, you can use to analyze the replication system. Check the troubleshooting section of the problem category for detailed information. This section summarizes the available diagnostic tools.
Use:
isql to log in to a Replication Server or data server to see if servers are up. You can also use isql to execute SQL commands to see if data is the same in the primary and replicate databases, or if data has been materialized or dematerialized.
admin who_is_down to find out which Replication Server threads are down.
admin who, sqm to display information, such as the number of duplicate transactions or the size of stable queues, about stable queues at a Replication Server.
admin who, sqt to display information, such as the number of open transactions, about stable queues at a Replication Server.
admin stats, md to display information, such as the number of messages delivered, about messages delivered by a Replication Server.
sp_config_rep_agent to display the current RepAgent configuration settings.
sp_help_rep_agent to display static and dynamic information about a RepAgent thread.
sysadmin dump_queue to dump stable queues and view them.
rs_helproute to display the status of routes at a Replication Server.
rs_subcmp to compare a subscription’s tables in the primary and replicate databases to make sure the tables are the same.
check subscription to display the status of subscriptions at a Replication Server.
rs_helppub to display publications.
rs_helppubsub to display publication subscriptions.
sp_setrepcol to check the replication status of text, unitext, or image columns.
