Diagnostic tools retrieve the status and statistics of Replication Server components. Depending on the type of problem, use these status and statistics to analyze the replication system.
isql – use to log in to a Replication Server or data server to see if servers are running. 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 – identifies which Replication Server threads are down.
admin who, sqm – displays information, such as the number of duplicate transactions or the size of stable queues, about stable queues at a Replication Server.
admin who, sqt – displays information, such as the number of open transactions, about stable queues at a Replication Server.
admin stats, md – displays information, such as the number of messages delivered, about messages delivered by a Replication Server.
sp_config_rep_agent – displays the current RepAgent configuration settings.
sp_help_rep_agent – displays static and dynamic information about a RepAgent thread.
sysadmin dump_queue – dumps stable queues and lets you view them.
rs_helproute – displays the status of routes at a Replication Server.
rs_subcmp – compares a subscription’s tables in the primary and replicate databases. Use rs_subcmp to make sure the tables are the same.
check subscription – displays the status of subscriptions at a Replication Server.
rs_helppub – displays publications.
rs_helppubsub – displays publication subscriptions.
sp_setrepcol – checks the replication status of text, unitext, or image columns.