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.

Re: Diagnose Application bottleneck

It's actually IIS5 on Win2K but anyway ........ I realise you've mentioned
logging and monitoring but, have you tried monitoring both of the servers
concurrently? (this will allow you to determine if it is one and/or both
servers causing it).

One of the preferred tools to use is a program called IISState

http://www.iis-resources.com/modules/AMS/viewlink.php?lid=14 17

Pretty sure it comes with the IIS res kit .... might want to post the
results from BOTH of the servers here and the experts will take a look at
them for you ;o)

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Roger Twomey" wrote in message
news:%23KGsmxsbGHA.2396@TK2MSFTNGP02.phx.gbl...
> 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.
>
>

Re: Diagnose Application bottleneck

I have followed the link. This lead me to a new page with a link to the IIS
State app, but it gives me a 404 error.

http://www.iis-resources.com/downloads/IISState.msi

is now a dead link.

Any idea where it might have gotten moved to?

Thanks.

"Steven Burn" wrote in message
news:uGgZ3RvbGHA.1960@TK2MSFTNGP05.phx.gbl...
> It's actually IIS5 on Win2K but anyway ........ I realise you've mentioned
> logging and monitoring but, have you tried monitoring both of the servers
> concurrently? (this will allow you to determine if it is one and/or both
> servers causing it).
>
> One of the preferred tools to use is a program called IISState
>
> http://www.iis-resources.com/modules/AMS/viewlink.php?lid=14 17
>
> Pretty sure it comes with the IIS res kit .... might want to post the
> results from BOTH of the servers here and the experts will take a look at
> them for you ;o)
>
> --
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
> "Roger Twomey" wrote in message
> news:%23KGsmxsbGHA.2396@TK2MSFTNGP02.phx.gbl...
>> 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.
>>
>>
>
>

Re: Diagnose Application bottleneck

You can get it in the IIS6 res kit at;

http://www.microsoft.com/downloads/details.aspx?FamilyId=56F C92EE-A71A-4C73-B628-ADE629C89499&displaylang=en

Or the individual file at;

http://www.iisfaq.com/default.aspx?view=P197

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Roger Twomey" wrote in message
news:OZMl0Y3bGHA.3504@TK2MSFTNGP04.phx.gbl...
> I have followed the link. This lead me to a new page with a link to the
IIS
> State app, but it gives me a 404 error.
>
> http://www.iis-resources.com/downloads/IISState.msi
>
> is now a dead link.
>
> Any idea where it might have gotten moved to?
>
> Thanks.
>
> "Steven Burn" wrote in message
> news:uGgZ3RvbGHA.1960@TK2MSFTNGP05.phx.gbl...
> > It's actually IIS5 on Win2K but anyway ........ I realise you've
mentioned
> > logging and monitoring but, have you tried monitoring both of the
servers
> > concurrently? (this will allow you to determine if it is one and/or both
> > servers causing it).
> >
> > One of the preferred tools to use is a program called IISState
> >
> > http://www.iis-resources.com/modules/AMS/viewlink.php?lid=14 17
> >
> > Pretty sure it comes with the IIS res kit .... might want to post the
> > results from BOTH of the servers here and the experts will take a look
at
> > them for you ;o)
> >
> > --
> > Regards
> >
> > Steven Burn
> > Ur I.T. Mate Group
> > www.it-mate.co.uk
> >
> > Keeping it FREE!
> >
> > "Roger Twomey" wrote in message
> > news:%23KGsmxsbGHA.2396@TK2MSFTNGP02.phx.gbl...
> >> 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.
> >>
> >>
> >
> >
>
>