Post reply

Web site very very slow

  • October 17, 2014 at 7:49 am

    #300242

    Over the past week or so, SSC has been extremely slow.

    There is no consistency. A link is clicked, it takes 2 -3 minutes. Another link is clicked, it loads immediately.

    I use Chrome and IE, both are the same.

    This occurs at home or work, so it's not the network.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • October 18, 2014 at 3:50 pm

    #1753321

    Thanks. We've had a few issues, and we're trying to track down the problems.

  • October 18, 2014 at 3:55 pm

    #1753323

    Need any help???

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • October 20, 2014 at 8:25 am

    #1753511

    Always, but not sure how to coordinate things.

  • November 4, 2014 at 5:01 am

    #1756499

    Michael L John (10/17/2014)

    Over the past week or so, SSC has been extremely slow.

    Michael, did you happen to notice whether it affected the forums in particular, or the whole site?

    I've just deployed an update to the forums that seems to have substantially improved the performance there, so would be interested to hear if that's made things better for you.

    Thanks,

    Rob

    Red Gate

  • November 4, 2014 at 8:55 am

    #1756563

    The main issue was when I clicked a link to go to a post on the forums from the main page.

    But, this same thing occurred when clicked other links as well, such as an article.

    It seems much faster today. I will keep monitoring!

    Thanks!

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • November 4, 2014 at 8:57 am

    #1756564

    OK, thanks - the CPU load on the web servers is much reduced now, not that it was ever close to maxing them out, so it could have been causing some queueing within IIS previously.

    Let me know how you get on in any case.

    Thanks,

    Rob

  • November 4, 2014 at 10:17 am

    #1756586

    I saw the same thing, but it seems to be performing very well today.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • November 4, 2014 at 10:50 pm

    #1756654

    I'm also finding it randomly slow. I've mostly stopped checking the forum due to how slow it is.

    Right now it took about 30 seconds to open this thread.

  • November 6, 2014 at 6:08 am

    #1756967

    Good morning, all,

    I know this may be a long shot, but I checked out your "SQL Monitor" page and saw something that may or may not be related.

    There are several low threshold alerts related to long-running queries, and most seem to be related to a "RedGate_RemoveSPAM" procedure. Perhaps the website is being inundated with SPAM postings through some exploit, and the procedures are running overtime removing the SPAM posts. The SPAM posts may not appear on the site, but I'm sure the SPAMMING combined with the automated removal causes some performance hit on the front-end?

    My two bits... Thanks!

    Jonathan

  • November 6, 2014 at 6:15 am

    #1756973

    Thanks, Jonathan - good spot.

    That sproc is largely out of date now in any case, since we now run forum posts through Akismet, which is much smarter than the relatively brute-force approach of that implementation.

    I've dropped its frequency down so it's running daily (to catch anything that does happen to make it through Akismet!) at 0300 instead of every ten minutes throughout the day.

    Any other observations on forum speed welcome...

    Thanks,

    Rob

    Red Gate

Viewing 11 posts - 1 through 10 (of 10 total)

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