November 16, 2011 at 8:46 am
I have been working on several programs. I want one to report on the current number of replication records in process by publication. I am creating another report on the details of replication. My thought was, 'if I create this on the distribution server, I should be able to get all the comprehensive information I need."
There are so many tables available on the publisher and the distributor, it is kind of rediculous trying to build this without a solid Msft doc that says: Here is how to properly create this kind of query.
Here is my question: Is there any problem using the catalog tables on the distributor?
Q2: Is there any reason why I might want to create the second report on the publisher rather than the distribution server?
Q3: Is this the best source for information on the entire description of a replicated table? Here is my FROM clause.
FROM [dbo].[MSsubscriptions]s
, [dbo].[MSpublications]p
, [master].[dbo].[sysservers]masys
, [master].[dbo].[sysservers]masys2
, [dbo].[MSarticles]MSart
, [dbo].[MSdistribution_agents]MSdist
Q4: Is sp_replmonitorsubscriptionpendingcmds considered the standard in terms of monitoring current transactions in processing?
Thanks in advance for your feedback. Replication geeks! Where are you?
November 16, 2011 at 12:24 pm
Not fully understanding what your asking for, but if you want to see undistributed commands then run:
use [distribution]
go
select d.*, a.article, s.name from MSdistribution_status d
inner join MSdistribution_Agents s on d.agent_ID = s.id
inner join MSarticles a on d.article_id = a.article_id
and s.subscriber_db != 'virtual'
order by UndelivCmdsInDistDB desc
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply