Tag Archives: Replication

View Top 1000 Outstanding Replicated Commands

To view (browse) the top 1000 outstanding replicated commands execute the following script:

Posted in Replication | Tagged | Comments Off on View Top 1000 Outstanding Replicated Commands

View All Outstanding Replicated Commands

To view (browse) the replicated commands that are outstanding the stored procedure sp_browsereplcmds should be executed. Please note that if you many transactions outstanding it may take a while for the result set is returned: exec distribution..sp_browsereplcmds

Posted in Replication | Tagged | Comments Off on View All Outstanding Replicated Commands

Number of SQL Commands Awaiting Distribution

To count the number of replicated commands that are outstanding the MSrepl_commands table should be queried on the distribution database as follows:

Posted in Replication | Tagged | Comments Off on Number of SQL Commands Awaiting Distribution