Slow Web applications
Hi
One of my clients has developped in house Web applications
using the classic tools available: HTML, PHP, Java, SQLServer
They have deployed these apps to remote agencies based
in the West Indies; these are connected with have 2Mbps
SDSL uplinks
They often complain of sluggish responses
They can click on a roll out list and at best count till five for the list to appear,
same thing with button clicks.
I have been trying to help them out by adjusting the agencies' routers
to reserve bandwith for these remote accesses; so far my impact hasn't
been that impressive
I always ask the remote users whether normal Web browsing is fine or
similarly affected. In most cases standard navigation works fine.
I'm not a developper so I'm not really able to advise them on the
quality of their developments
The developpers themselves seem pretty confident that it isn't the
apps causing the sluggishness - when they access them from here
all seems fine
The apps are normally housed in a data center
A storm wreaked havoc about two months ago so they relocated
some of their apps on their local office servers. The symptoms
are unfortunately still the same
Any ideas, pointers ?
thanks
yann
One of my clients has developped in house Web applications
using the classic tools available: HTML, PHP, Java, SQLServer
They have deployed these apps to remote agencies based
in the West Indies; these are connected with have 2Mbps
SDSL uplinks
They often complain of sluggish responses
They can click on a roll out list and at best count till five for the list to appear,
same thing with button clicks.
I have been trying to help them out by adjusting the agencies' routers
to reserve bandwith for these remote accesses; so far my impact hasn't
been that impressive
I always ask the remote users whether normal Web browsing is fine or
similarly affected. In most cases standard navigation works fine.
I'm not a developper so I'm not really able to advise them on the
quality of their developments
The developpers themselves seem pretty confident that it isn't the
apps causing the sluggishness - when they access them from here
all seems fine
The apps are normally housed in a data center
A storm wreaked havoc about two months ago so they relocated
some of their apps on their local office servers. The symptoms
are unfortunately still the same
Any ideas, pointers ?
thanks
yann
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It could still be either the connection or application/server problem but I am leaning more towards the app/server problem; but without additional testing you will not be able to identify the source of the problem.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Ray
They are using Microsoft SQL Server
I suppose the syntax of stopwatch will be more or less the same ?
They are using Microsoft SQL Server
I suppose the syntax of stopwatch will be more or less the same ?
Yes, the Stopwatch will work fine. I'm not conversant about SQL Server, but I can add it to the topic areas and maybe we can get some other eyes on the issues.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Fibo
I personally use PRTG from Paessler; but I haven't had time lately to really sit down and set the proper monitoring sensors in place in order to follow what is going on at the remote sites in terms of traffic consumption.
I will do this in January - December is high in activity for this client and any modifications or tweaks are absolutely prohibited during this period.
Servers are located in a datacenter, and most are single tasked - one harbors both WEB and SQL servers
There are no * selects, backups execute on Sundays, there are no images or videos on their web pages or in their databases, external accesses used by WebServices employ IP addresses, as for RAM utilization from what I understand SQL Server takes it all and uses it as it sees fit
I transmitted the stopwatch module to them.
I personally use PRTG from Paessler; but I haven't had time lately to really sit down and set the proper monitoring sensors in place in order to follow what is going on at the remote sites in terms of traffic consumption.
I will do this in January - December is high in activity for this client and any modifications or tweaks are absolutely prohibited during this period.
Servers are located in a datacenter, and most are single tasked - one harbors both WEB and SQL servers
There are no * selects, backups execute on Sundays, there are no images or videos on their web pages or in their databases, external accesses used by WebServices employ IP addresses, as for RAM utilization from what I understand SQL Server takes it all and uses it as it sees fit
I transmitted the stopwatch module to them.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the points, but were you actually able to pin down a cause for your problem?
ASKER
no not yet
same here... did you do any extra debug ?
feel free to post, we may be able to help
feel free to post, we may be able to help
ASKER
What I forgot to mention is that this sluggish behaviour seems to come and go throughout the day
It can be globally sluggish with improvements occuring now and again
And for some it is application A which is slow while application B is fine, and for others it will be the complete opposite, or both.
I'm not these last comments will be useful or whether they will cloud the situation even further
yann