Performance questions on SQL Server 2K

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: dw (cougarmana_NOSPAM_at_uncw.edu)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 13:10:13 -0400

Hello, all. We were directed by Mark Schupp in the ASP newsgroup
(microsoft.public.inetserver.asp.general) to post this here and see if
anyone has an answer. He thought it might be a problem with the SQL Server
and not the web server. The apps with problems hit our SQL Server 2K across
the network. We've had occasions where we get Timeout Expired errors in some
of our ASP apps, and non-ASP vendor apps on separate servers that hit the
SQL Server get into the same problem of hourglassing and not coming back.
When the admins reboot the SQL Server machine, it clears it up for awhile.

What we're wondering is this: Is it the web server, the network, or the SQL
Server that is creating this headache? During the times when we've had those
issues, we've immediately started running the Performance Monitor to see if
we can track the issue, with the following counters added:
    - Request Wait Time (ASP)
    - Requests Executing (ASP)
    - Requests Timed Out (ASP)
    - Pages/sec. (Memory)
    - % Processor Time

We didn't see the above items spike during the times users were getting the
Timeout Expired errors. How can we look at one individual ASP application to
see if we can rule it out as the culprit? Also, how can we tell if this is
caused by the network or the database server?

Thanks.

Relevant Pages

  • Re: Adp to asp web page
    ... of drunk retards that dont understand web development ... when I went into the connection box, it listed my server but in the drop ... Access ADP is merely front end app and IDE for SQL Server, ... ASP is old technology and different from ASP.NET. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Confused about ASP, "sessions", and queuing of multiple requests
    ... cookies (include ASP session state cookie) with the first IE instance. ... and generating multiple HTTP requests from a single IE ... :> running IIS on a multiprocessor server. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Confused about ASP, "sessions", and queuing of multiple requests
    ... cookies (include ASP session state cookie) with the first IE instance. ... and generating multiple HTTP requests from a single IE ... :> running IIS on a multiprocessor server. ...
    (microsoft.public.inetserver.iis)
  • Cluster questions
    ... I need to install a portal infrastructure that was developed with ASP ... and SQL Server. ... Virtual Server), like NLB. ... The developement of the ASP application is different that the ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to Set Datetime on SQL 2000 server
    ... the site on the new server still links to the same SQL ... The asp pages on this new server works fine with all date data. ... least pass language neutral datetime formats to SQL Server ... the desired format. ...
    (microsoft.public.sqlserver.setup)