Diagnose Application bottleneck

I am looking at an application which runs from Windows 2000 server, IIS 5.5
(I think, 5.x anyway) using ASP.

The site is load balanced between two servers using Windows Loadbalancing.

The site runs fine 95% of the time however, there are times when the site
slows down dramatically, eg: waiting one minute for a page to load.

This seems to happen when the application is running with over about 150
concurrent users. It uses ASP for the front end and SQL server 2000 running
on another server for the back end.

We have tried monitoring the application and the database server to see if
we can find anything significant.

The SQL server tends to use less than 30% CPU with occassional spikes to 60%
or 70% which immediately drop back down. The SQL server has been monitored
and we are not seeing any deadlocks occuring. The majority of the sql is
select statements so this should not be an issue anyway.

The memory use on the sql server sits consistently at about 55% committed in
use.

The web server has also been monitored. We have seen the following:

CPU Use is normally below 20% with occasional spikes to 30 - 35%.
Committed memory in use is about 20%
Requests Executing between 5 - 15
Requests Queued between 2 - 5

(Note time intervals are all seconds.)

The requests queued is normally 0, but under this load we see some small
number being queued.

I have not been able to figure out where the bottleneck is. If I can
pinpoint the problem area in the system, then fixing it should become fairly
easy.

Any Suggestions how to diagnose this?

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: What is the difference between php & asp?
    ... >ASP is a Microsoft product based on the very ackward Visual Basic syntax ... >PHP is a C-Like, ... >need to physically register on the server. ... It works fine with SQL Server and Access if you really really ...
    (alt.php)
  • 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)
  • Re: Locked out of my own SQL Server???
    ... >back on the original server, it's trying to get onto SQL ... within my ASP ... >> app to use an applicationwide Connectionstring Variable ... >> Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.inetserver.iis.security)