Post reply

distribution agent

  • April 27, 2008 at 3:00 pm

    #184916

    hi,

    the distribution agent says that the process is running and waiting for response from the server .

    i have replication set up for different locations.

    only one location bothers me.

    it runs for hours and it will not get complete for quite a few days.

    once it is done i am missing the data for few days.

    can you please tell to me how to make the distribution agent run faster with out much delays.

    thank you,

  • April 28, 2008 at 7:34 am

    #807754

    Last time I saw this it was due to really bad network connectivity between the publisher and the distributor.

    Check your network, check the settings on the cards, check the available bandwidth, etc.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 28, 2008 at 10:46 am

    #807929

    How many commands are sitting in the queue?

    waiting for the server to response means that the distribution agent is reading the cmd table and preparing those to be replicated. If there are a lot of commands, it will sit there and sit there until it is done. However, if you are using the default distribution agent profile, it will time out in 1800 seconds.

    All you need to do is create a new distribution agent and set the queryTimedOut value to 65000 and wait it out. Don't try to perform a network trace or ping now because those numbers will be out of whack.

    And yup, sometimes it is the network connectivity between the two servers.

    -----------------------------
    www.cbtr.net
    .: SQL Backup Admin Tool[/url] :.

  • April 28, 2008 at 2:23 pm

    #808038

    thank you i will check that out

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply