Extreme slowness

  • The site is extremely slow.  
    It's taking as long as 2-3 minutes for a link to work.

    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/

  • Michael L John - Wednesday, October 18, 2017 2:49 PM

    The site is extremely slow.  
    It's taking as long as 2-3 minutes for a link to work.

    Agreed. Took approximately one minute just to open this thread.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • We are experiencing some CPU issues on the web servers. The db server seems to be fine. Our IT group is investigating.

  • Steve Jones - SSC Editor - Wednesday, October 18, 2017 7:25 PM

    We are experiencing some CPU issues on the web servers. The db server seems to be fine. Our IT group is investigating.

    We've had that happen where we work.  The "fix" was to restart IIS.

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

  • If it's IIS, there are a couple things that we have run into. 
    If there is any 32 bit code, IIS can't address memory.  Re-starting it worked.  Getting rid of the 32 bit code worked better!
    Re-cycling the app pools may also need to be looked at. Depending upon the connections, when a recycle occurred, CPU went through the roof.

    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/

  • We are implementing a new web server and a flip is scheduled soon. The old one is going to be available if we have issues.

  • Steve Jones - SSC Editor - Thursday, October 19, 2017 10:35 AM

    We are implementing a new web server and a flip is scheduled soon. The old one is going to be available if we have issues.

    Good info, Steve.  Thanks for the update.  It was really getting bad.  Looking forward to the update in November because even this post took 8 seconds to post.

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

  • New web server should be online.

  • Thanks, Steve.  It seems to have helped quite a bit but don't know for sure because things seem to calm down about this time of day every day.

    Please tell the folks that stood up the box that we really appreciate their efforts.

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

  • FWIW, we brought a second web server online today. Let me know here if performance is better or worse.

    Our IT group was hesitant to do this as these forums store their attachments on local storage. With old WS2003 servers, we don't have a good shared storage location at the moment. The compromise is that we have a sync job that moves stuff back and forth every 5 minutes. If you get inconsistency with attachments, that's probably it. Wait a few as it will resolve before we can respond to a note.

  • Steve Jones - SSC Editor - Thursday, October 26, 2017 9:20 AM

    FWIW, we brought a second web server online today. Let me know here if performance is better or worse.

    Our IT group was hesitant to do this as these forums store their attachments on local storage. With old WS2003 servers, we don't have a good shared storage location at the moment. The compromise is that we have a sync job that moves stuff back and forth every 5 minutes. If you get inconsistency with attachments, that's probably it. Wait a few as it will resolve before we can respond to a note.

    It seems quite responsive compared to what it used to be.  Thanks, Steve.

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

  • Cheers. Hopefully we could move to 3 if needed.

    More hopefully this will get us through a WS/SQL upgrade.

  • It's far faster over the past week.  Thanks Steve!

    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/

  • Good to hear. I think we stil have some optimization routines in the .NET side, as the database seems to be working fine:

    http://monitor.red-gate.com/overviews/cluster/254914-ntclus.lon.intensive.int/sql/ins1

  • Steve Jones - SSC Editor - Friday, October 27, 2017 8:26 AM

    Good to hear. I think we stil have some optimization routines in the .NET side, as the database seems to be working fine:

    http://monitor.red-gate.com/overviews/cluster/254914-ntclus.lon.intensive.int/sql/ins1

    Thanks Steve, good link. That monitoring software looks familiar 😉

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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