Did anyone else experience a massive slowdown of Jodo served sites? From about 9am mountain standard time until about 10:45am I could not access any Jodo sites. I’m just trying to figure out what might have happened?
I noticed that EVERYTHING is slow these last few days, not just servers…
Do you notice that things are a little faster now than they were earlier?
VividWeb, no outage between those times have been reported to us. Did you take a traceroute between those times? If so please PM it to me.
Dave96, which server are you on? You can check the server response times from the jodopulsr report page
Doing work on my DNN site last night between 7:00pm and 10:00pm US Eastern Time was slow at times. Very slow. Other times it would be fast.
I’m seeing it again at 11:00am EST.
I’m on win10 and using mssql5. I think the problem is on mssql5 because:
-
My other asp.net site on win10 that does not use MSSQL does not have these problems.
-
Even going into control panel and looking at info on my SQL database is slow.
I hope this info helps. Its painfully slow at times. I hope you can get it fixed because its usually very snappy response for me.
Thanks.
All the servers my domains are on have been slow for the last week or more. I figured the servers were overloaded. The ping to the server is very fast, it’s the server parsing out php/asp.net scripts and actually serving the page. I dont know what the heck is going on, but this slowdown seem to by happening on a weekly basis now 
MSSQL5 is being monitored by us. it has had some slow patches in the last week and we are working to track down whats the causing the spikes (most likely a customer with a heavy-duty search routine).
At the moment things are fine, please feel free to submit a ticket if you experience it again
[QUOTE=Shannara]
All the servers my domains are on have been slow for the last week or more. I figured the servers were overloaded. The ping to the server is very fast, it’s the server parsing out php/asp.net scripts and actually serving the page. I dont know what the heck is going on, but this slowdown seem to by happening on a weekly basis now
[/QUOTE]
All servers cannot be slow. They are defiantely not overloaded. Check the jodopulse reports on serverload or response times.
Please send in a traceroute or please post you website here.
[QUOTE=Shannara]
All the servers my domains are on have been slow for the last week or more. I figured the servers were overloaded.(
[/QUOTE]
What servers are you using that are slow?
JH limits the number of sites on a server and monitors the server utilization pretty close. They don’t let their stuff get over loaded. Unlike many other hosts. :] However, with hundreds of accounts there is always the chance of someone doing something they shouldn’t be doing. This can be the case when someone writes their own code and it is not optimized as well as it should be. JH has to chase them down and handle the problem on a case by case basis.
[QUOTE=Yash]
MSSQL5 is being monitored by us. it has had some slow patches in the last week and we are working to track down whats the causing the spikes (most likely a customer with a heavy-duty search routine).
At the moment things are fine, please feel free to submit a ticket if you experience it again
[/QUOTE]
Its good to know that JH is on the case. Thanks Yash. But when I experience the problem is is there one minute and gone the next so submitting a ticket will probably not do me much good. Since I know you’re monitoring this server I’ll just trust that you’re fixing the problem. Thanks again.
[QUOTE=Dave96]
I noticed that EVERYTHING is slow these last few days, not just servers…
[/QUOTE]
You mean the internet is generally slow?
I am not seeing this slowness. Network response times I am getting are snappy. There are two load issues we are aware of this month:
- Win11.. this was last week and fixed
- Web3 - had some brief slow patches due to a user script.. corrected but being monitored
- mssql5 - we are investigating this.. This may be causing some customers to experience slow response times occasionally.. if you are using mssql5
Web3 - Has been giving 2 or 3 minute brief slow down periods this morning. Its likely that someone is running a script from time to time, making this issue hard to track down.. But we are aware this server is having brief slow patches and are putting everything in to catch the abuser
MSSQL5 - we should have these load issues resolved soon. I’ve asked Stephen to give us some assistance, hes currently on holiday. He has more experience with MSSQL abuse issues. The issue isnt continuous as you rightly pointed out.. there are brief load spikes.. due to a very heavy search routine (probably). I have been working on this for several hours.. Very hard to catch
[QUOTE=Yash]
Web3 - Has been giving 2 or 3 minute brief slow down periods this morning. Its likely that someone is running a script from time to time, making this issue hard to track down.. But we are aware this server is having brief slow patches and are putting everything in to catch the abuser
MSSQL5 - we should have these load issues resolved soon. I’ve asked Stephen to give us some assistance, hes currently on holiday. He has more experience with MSSQL abuse issues. The issue isnt continuous as you rightly pointed out.. there are brief load spikes.. due to a very heavy search routine (probably). I have been working on this for several hours.. Very hard to catch
[/QUOTE]
Is there no backup for Stephen? I’m concerned if he is the only SQL expert on staff.
Stephen is our most experienced Windows tech. There are other certified windows techs on our team, but really experience counts on such issues and our admins do refer to a senior admin (in both windows and linux) if we have a difficult issue.
We have located the problem database on MSSQL5
The way we are structured is that we have a top Windows admin, and a top linux admin. Under these two individuals, we have techs with varying experience levels.
Ok thanks Yash for hte clarification. Just wanted to make sure you had proper support in place in case anything happens.
[QUOTE=Yash]
We have located the problem database on MSSQL5
[/QUOTE]
Thats great Yash. Without giving away any personal information about the problem database can you tell us something about exactly what was the problem? Large database, improper indexing, just heavy use, etc? Just wondering.
The database was having heavy usage more than everything, I ran the profiler on it for just a matter of 2-4 seconds, and had a massive page full of small queries. I was tracking its CPU usage and found it as the cause, then profiled for a few seconds as to find what was causing the problem. It was not one specific query as much as the sheer number of queries.
Is the EM Management screen, I could see 8 connections for this DB, and of those 8 connections each one was processing a query a second, and some of them even more than that.