SQL Server Replication

• lianvh 89542

  SSCommitted

  Points: 1561

  More actions

  July 2, 2013 at 1:58 am

  #295224

  Good Day. We configured a pull Replication with the Distributor residing on the Publisher. I am able to see transactions going to the Distributor, but I would like to know how one can monitor the transactions going FROM the Distributor TO the Subscriber .

• saran.dharsh

  Right there with Babe

  Points: 723

  More actions

  July 2, 2013 at 3:16 am

  #1628956

  do you need to monitor pending commands from distributor to subscriber?

  if You need to check article wise pending commands kindly make use of below query , it has to execute in distributor server in distribution database..

  SELECT MsPDb.Publisher_DB

  , MsArt.article

  , Count(*) AS [Number of Commands Pending]

  FROM MSrepl_commands MsRCm (NOLOCK)

  JOIN MSpublisher_databases MsPDb (NOLOCK) ON MsPDb.id = MsRCm.publisher_database_id

  JOIN MSarticles MsArt (NOLOCK) ON MsRCm.article_id = MsArt.article_id

  AND MsPDb.Publisher_DB = MsArt.Publisher_DB

  WHERE MsPDb.Publisher_DB = '' ----- Your database Name here

  GROUP BY MsPDb.Publisher_DB

  , MsArt.article

  ORDER BY 1, 3 DESC

• lianvh 89542

  SSCommitted

  Points: 1561

  More actions

  July 2, 2013 at 11:23 pm

  #1629358

  Thank you for the feedback. I need to compare the publisher database with the subscriber database .

• Modest DBA

  SSC Eights!

  Points: 816

  More actions

  July 3, 2013 at 3:43 am

  #1629445

  Hi

  a simple GUI will be the Replication monitor, it displays from start to finish.

• PRAMANA.DBA

  SSCertifiable

  Points: 5507

  More actions

  July 3, 2013 at 6:12 am

  #1629494

  Hi,

  You want to see DB comparison or Replication monitor , If u want see replication status, using replication monitor window in server explorer .

  Thanks,

  RR