October 18, 2017 at 2:49 pm
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/
October 18, 2017 at 3:40 pm
Michael L John - Wednesday, October 18, 2017 2:49 PMThe 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
October 18, 2017 at 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.
October 19, 2017 at 7:57 am
Steve Jones - SSC Editor - Wednesday, October 18, 2017 7:25 PMWe 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
Change is inevitable... Change for the better is not.
October 19, 2017 at 8:10 am
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/
October 19, 2017 at 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.
October 19, 2017 at 5:19 pm
Steve Jones - SSC Editor - Thursday, October 19, 2017 10:35 AMWe 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
Change is inevitable... Change for the better is not.
October 20, 2017 at 2:33 pm
New web server should be online.
October 20, 2017 at 3:53 pm
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
Change is inevitable... Change for the better is not.
October 26, 2017 at 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.
October 26, 2017 at 2:09 pm
Steve Jones - SSC Editor - Thursday, October 26, 2017 9:20 AMFWIW, 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
Change is inevitable... Change for the better is not.
October 26, 2017 at 3:03 pm
Cheers. Hopefully we could move to 3 if needed.
More hopefully this will get us through a WS/SQL upgrade.
October 27, 2017 at 8:18 am
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/
October 27, 2017 at 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
October 27, 2017 at 8:31 am
Steve Jones - SSC Editor - Friday, October 27, 2017 8:26 AMGood 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