Extreme slowness

Question

Extreme slowness

Michael L John

One Orange Chip

Points: 27055
More actions
October 18, 2017 at 2:49 pm

#402607

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/

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

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

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

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

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)

Michael L John One Orange Chip Points: 27055 More actions · Answer 4

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/

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

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.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 6

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)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 7

Steve Jones - SSC Editor

SSC Guru

Points: 736212

October 20, 2017 at 2:33 pm

#1964591

New web server should be online.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 8

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)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 9

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.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 10

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)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 11

Cheers. Hopefully we could move to 3 if needed.

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

Michael L John One Orange Chip Points: 27055 More actions · Answer 12

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/

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 13

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

Phil Parkin SSC Guru Points: 246960 More actions · Answer 14

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