Can Somebody answer this simply and briefly please?

  • 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?

  • 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

  • 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
  • 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