Avatar of Yann Shukor
Yann Shukor
Flag for France asked on

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
Web DevelopmentPHPApache Web ServerMicrosoft SQL ServerPaessler

Avatar of undefined
Last Comment
skullnobrains

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Paul MacDonald

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Uros Gaber

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Yann Shukor

ASKER
Thanks

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
Uros Gaber

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
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Yann Shukor

ASKER
Thanks Ray

They are using Microsoft SQL Server

I suppose the syntax of stopwatch will be more or less the same ?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Ray Paseur

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
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Yann Shukor

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.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Paul MacDonald

Thanks for the points, but were you actually able to pin down a cause for your problem?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Yann Shukor

ASKER
no not yet
skullnobrains

same here... did you do any extra debug ?
feel free to post, we may be able to help