Slow web page

[MSDN]

Hello,

I have a web page that use to take about 6 seconds to load. Now it is
taking 24 seconds
The maximum number of records sending back is 200.
The SQL SP is executing in 3-4 seconds and never more than 6 seconds.

This happened overnight, no code has been changed, no sql sps has been
changed, no web pages has been changed
This also happens even if I have only 1 user on the web site.

What should I be looking for??
Any help is appreciated. This is not a public web site and I can not share
the URL. Sorry.
If I am to use PerfMon and I did what should I be looking at specifically...


Thank you for any help, Ideas, Links, etc..

SA

 

[Guest]

MSDN,
Until you post sufficient sample working code to be able to replicate the
issue, I doubt you'll be able to get much more than some "shoot in the dark"
ideas from readers on this. Stuff about connections, why does the Stored
proc take so long, and so on.
Peter

 

[Alvin Bruney - ASP.NET MVP]

have you done anything on your own to trouble-shoot the problem? If so post
it here.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/

 

[sirfunusa]

Copy the page to a new one, and remove everything except the SQL logic,
and go from there. Add code back in until you find the problem. Basic
troubleshooting technique.

 

[MSDN]

Peter,

It has nothing to do with the code, the code was never touched
The SP takes 3-4 seconds becasue it is a nasty 32 join, union etc..
so we can live with 3-4 seconds to get 200 records.
The issue here why it is taking now 24 seconds to get the web page to load
the SP still executing in 3-4 seconds.
There must be a list of things a person can go through.

Thank you for your input.

SA

 

[MSDN]

Alvin,

Yes what I did is the following.

I checked if my SP still takes 3-4 seconds to execute and the answer is YES
and YES
The Maximum number of records returned is 200 and this has very little data.
The Maximum web page size is 183,947 bytes which is nothing
I traced the code and I don't see any errors or try catch issues.
When I run the same web site locally on my slow laptop it takes only 6
seconds for the page to load.
This web site is accessed locally in an Intranet environment.

I don't really know what else to look for at this time.
But still thinking....

Thank you for any hints, shoot in the dark stuff etc..

SA

have you done anything on your own to trouble-shoot the problem? If so
post
it here.

--
Warm Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley 2006
Blog: http://msmvps.com/blogs/Alvin/
-------------------------------------------------------

Hello,

I have a web page that use to take about 6 seconds to load. Now it is
taking 24 seconds
The maximum number of records sending back is 200.
The SQL SP is executing in 3-4 seconds and never more than 6 seconds.

This happened overnight, no code has been changed, no sql sps has been
changed, no web pages has been changed
This also happens even if I have only 1 user on the web site.

What should I be looking for??
Any help is appreciated. This is not a public web site and I can not share
the URL. Sorry.
If I am to use PerfMon and I did what should I be looking at specifically...


Thank you for any help, Ideas, Links, etc..

SA

 

[sirfunusa]

Did you "try" my suggestion?

 

[sirfunusa]

Also, when the page finally loads, choose View Source, and save it as
normal HTML as a new page on your server. Then try accessing THAT page.

 

[MSDN]

sirfunusa,
I tried what you said and if I am not getting any data to return then it
works fine
It seems if I return any 200 records if is very slow
I will bounce the servers and see if that helps tonight

It was a very good suggetion

Thank you,

SA

 

[MSDN]

I did this already and It seems that the web server is suffering.
I checked how many users on the server and only about 10 users at a time
There is no Denial of service attacks present at least according to the
Administrators

Will bounce it tonight and that might do it.

Lots of RAM available, HD space etc...

After bouncing the server in the past things improved but not for this web
server

Thank you sooo much for your help

SA

 

[sirfunusa]

Always test with simple pages to compare

 

[MSDN]

SirFunUSA

Rebooting the Web Server Resolved my problem.
Thanks for all you help.

SA