SQL Server Performance

The distributor

Discussion in 'Performance Tuning for SQL Server Replication' started by cj, Oct 3, 2003.

  1. cj New Member

    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.

    cj
  2. satya Moderator

    Check 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
  3. cj New Member

    Thanks Satya,

    Which one indicates the remaining data in the distribution database from Monitor ? Again, your help is greatly appreciated.

    cj
  4. satya Moderator

    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
  5. cj New Member

    Satya,

    You are the SQL God !!!

    cj
  6. satya Moderator

    No mention, glad to help.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page