SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How can i resolve undistributed commands in Transaction replication


How can i resolve undistributed commands in Transaction replication

Author
Message
Simha24
Simha24
Old Hand
Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)

Group: General Forum Members
Points: 398 Visits: 319
Hi,

We are reconfigured publication and subscription but undistributed commands to subscriber is showing very huge

No command to be distributed :7777


Please find the attachment....Help me how can i resolve this
Attachments
image001.png (111 views, 4.00 KB)
KumarVelayutham
KumarVelayutham
SSC-Addicted
SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)

Group: General Forum Members
Points: 462 Visits: 1352
Hi Friend,

If the number of undistributed commands was very high and increasing. Go and restart the sql server agent at the distributor, and like magic the undistributed commands was back down to 0 again.

Regards,
Kumar
Simha24
Simha24
Old Hand
Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)Old Hand (398 reputation)

Group: General Forum Members
Points: 398 Visits: 319
These commands need to be apply at subscriber right then how can i restart SQL Server Agent.....Is this resolve this kind off issues.

What it mean by undistributed commands. If i restart agent, How to these can be applied to subscribers.

In Replication monitor, Status of Subscriptions are showing as Uninitialized subscribers.
KumarVelayutham
KumarVelayutham
SSC-Addicted
SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)

Group: General Forum Members
Points: 462 Visits: 1352
From the replication monitor as you can see the value for Performance critical, Expiring soon/Expired, and Uninitialized subscription are warnings. When a warning is displayed, the Status column also displays if an agent is running. For example, the status could be Running, Performance critical. So confirm whether you see any value in Status column.

I believe the below steps wil answer for your queries..
1.I stopped SQL Server Agent on my Distribution server in order to effectively stop all replication jobs (although I probably could have manually stopped each of the individual replication jobs instead).
2.I re-ran EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 1 in order to clean-up the distribution history older than 1 hour. This outputted that no transactions were removed.
3.I re-ran sp_browsereplcmds and saw that I still had a number of transactions in MSrepl_commands.
4.I restarted SQL Server Agent which restarted all the replication jobs.
5.Magically, the undistributed commands went to zero!
6.A quick re-run of sp_browsereplcmds showed that I still had the same number of transactions in MSrepl_commands. I

Regards,
Kumar
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search