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 about stable queues at a Replication Server, such as the number of duplicate transactions, the size of stable queue, and the data loss status.
admin who, sqt – displays information about stable queues at a Replication Server such as the number of open transactions.
admin stats, md – displays information about messages delivered by a Replication Server such as the number of messages delivered.
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.