Post reply

Can Somebody answer this simply and briefly please?

  • January 23, 2013 at 8:36 am

    #269311

    Can Somebody answer this simply and briefly please? "We are experiencing long delays with SQL on the client replicating to the up-stream database server. Explain how what areas you would look at and how you would troubleshoot those areas?

  • January 23, 2013 at 8:49 am

    #1580137

    Shen1 (1/23/2013)

    "We are experiencing long delays

    1. Check the latency for the subscription/publication in the replication monitor, 2. Check for errors, 3) How many undistributed commands do you have for each problematic subscription? 4) Ask your System guys to check the network bandwidth usage between the 2 points - in the past I've experienced issues with millions of commands falling behind because there was simply too much going on across the pipe

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • January 23, 2013 at 9:03 am

    #1580151

    Interview question? Exam question?

    So, how would you start?

    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

  • January 23, 2013 at 10:46 am

    #1580197

    Start with the highest level and work down.

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

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