Slow site

  • Is anyone looking into how excruciatingly slow SSC has become?

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • mister.magoo (8/26/2015)


    Is anyone looking into how excruciatingly slow SSC has become?

    +1 and has been for the last few hours

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • +1000... there has to be a word worse than excruciating over the last couple of days. It's not consistently bad but it's been absolutely killer slow for extended periods over the last couple of days.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • We are looking. We had some strange networking problems between the DB and website. We have a ticket open with the colocation facility

  • Hi folks,

    Really sorry about these issues - we're well aware of them, and working with the hosting company on them.

    Basically, we're seeing intermittent packet loss between the SQL boxes and the front-end nodes (up to 10% with 1kB packets!), which is having the predictably devastating effect on performance.

    As of 1415 UTC, they have switched the path between the nodes to an alternate route, which is so far looking much healthier (no loss, and lower latency).

    We'll carry on watching for it, and carry on chasing appropriately...

    Cheers,

    Rob (Redgate IS team)

  • robert.chipperfield (8/26/2015)


    Hi folks,

    Really sorry about these issues - we're well aware of them, and working with the hosting company on them.

    Basically, we're seeing intermittent packet loss between the SQL boxes and the front-end nodes (up to 10% with 1kB packets!), which is having the predictably devastating effect on performance.

    As of 1415 UTC, they have switched the path between the nodes to an alternate route, which is so far looking much healthier (no loss, and lower latency).

    We'll carry on watching for it, and carry on chasing appropriately...

    Cheers,

    Rob (Redgate IS team)

    Thanks for feedback...at least we now know you are on the case....hopefully you will be able to resolve the issues quickly.

    At time of writing....site response seems good for me

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • From a monitoring point of view, it looks like things have remained stable since that change. If anyone is still seeing otherwise, please pop something on this thread.

    Thanks,

    Rob

  • robert.chipperfield (8/26/2015)


    From a monitoring point of view, it looks like things have remained stable since that change. If anyone is still seeing otherwise, please pop something on this thread.

    Thanks,

    Rob

    This was starting to sound like a cable gone bad or someone setting a router to auto-negotiate or half duplex.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Thanks for looking into it. It was pretty brutal this morning.

  • Bother - the issue is back as of a few minutes ago. Average 15% packet loss again starting 2052 UTC.

    Sorry all, normal service as soon as we can :-(.

    Cheers,

    Rob

  • For the curious, here's what the network traffic currently looks like between the two boxes:

    (Dark blue line is packet loss, light blue round trip time)

    The latest we have from the hosting provider is that one of their links is "saturated with customer traffic" (not ours!), and that we are not the only ones affected. Hopefully they'll get additional capacity sorted as soon as possible; if it's looking like it's going to go on for an extended period we will look at whether we can work around the issue any other way.

    Cheers,

    Rob

  • Very slow at 18:46 EDST. Ya just gotta love relying on 3rd parties. This and other problems we've seen over the last 5 years is why we don't do "Cloud" or 3rd party hardware providers. I do some part-time work for some companies that do and it's been a comparative nightmare not worth any potential cost savings.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • True, though comparatively speaking, on average I'm sure they do a better job than if we were to host SSC in Redgate Towers - not least, our internet connections and mains supply goes down a lot more often than at a proper datacenter ;-).

    Ultimately, unless you're big enough to be peering at multiple point of presence with physically diverse paths and so on, you're probably placing yourself in the hands of some collection of third parties. By and large, these folks have done us well over the years - it's been a very atypically bad week for them, so as frustrating as it is, I'm optimistic they will get it sorted and back to normal soon.

    Ironically, while watching this, my home DSL line has been showing similar packet loss for completely unrelated reasons, Dropbox has had issues, and so have ZenDesk. Obviously the internet got out of bed the wrong side today!

    Cheers,

    Rob

  • Heh... good grief. Between 20 and 60 seconds between every click now (10:30PM EDST). This is brutal. I sure hope you good folks can get to the bottom of this soon. Signing off for the night.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden (8/26/2015)


    Heh... good grief. Between 20 and 60 seconds between every click now (10:30PM EDST). This is brutal. I sure hope you good folks can get to the bottom of this soon. Signing off for the night.

    I was seeing the same thing at the same time. I was up to > 90 seconds to reply and gave up. Now (10:56 EDT) it's still around 60 seconds to bring up the page to submit a post.

  • Viewing 15 posts - 1 through 15 (of 42 total)

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