SQL Server Performance Forum – Threads Archive
The distributor
Hi SQL Wizards, One of our folks made a huge amount of updates in our replicated database system, and the distribution agent has been pushing for the last 28 hours. I am so anxious to know how much data is still remained in the distribution database ? Your help is greatly appreciated. cjCheck with Replication monitor about the status.
Also check thru the current activity about this transfer process from distributor. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Thanks Satya, Which one indicates the remaining data in the distribution database from Monitor ? Again, your help is greatly appreciated. cj
You can use DBCC OPENTRAN to get information about non-distributed transactions at Publisher. On the distribution side run the view MSdistribution_status (which I believe undocumented) which displays undelivered commands. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Satya, You are the SQL God !!! cj
No mention, glad to help. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>