Re: Slow web page

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

"Peter Bromberg [C# MVP]" <pbromberg@xxxxxxxxxxxxxxxxxxx> wrote in message
news:9E7D228E-022C-46BA-9A4A-05F93AC8CAED@xxxxxxxxxxxxxxxx
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

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com




"MSDN" wrote:

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





.

Relevant Pages

  • Slow web page
    ... I have a web page that use to take about 6 seconds to load. ... The maximum number of records sending back is 200. ... This happened overnight, no code has been changed, no sql sps has been ... This also happens even if I have only 1 user on the web site. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Slow web page
    ... I checked if my SP still takes 3-4 seconds to execute and the answer is YES ... This web site is accessed locally in an Intranet environment. ... I have a web page that use to take about 6 seconds to load. ... This happened overnight, no code has been changed, no sql sps has been ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [2.7 "thoughts"] V0.3
    ... > further abuse of the system unless the perpetrator was able to install and load ... and then use that program and an overflow sled to act as a poor-man's replacement ... exec-shield - We don't care if you're a trusted program, you're not executing off the stack. ...
    (Linux-Kernel)
  • Re: Cant Load Win/MS Update Pages
    ... Before I try to call tomorrow, is there some registry file I can edit ... I am unable to get to either web site from my daughter's computer. ... to load followed by an IE page failed to load message. ... regain access to the Win/MS Update sites? ...
    (microsoft.public.windowsupdate)
  • Re: Missing FTP link
    ... and that you should change it to My Network Places. ... I tried to load it to the site but got the error msg "cannot connect to ... Protocol) web site through a fire wall/proxy server and the proxy ...
    (microsoft.public.publisher.webdesign)
Loading