Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Troubleshooting 100%cpu problem with IIS

4 posts in General Discussion (old) Last posting was on 2000-03-07 22:50:01.0Z
Bill Bryant Posted on 2000-03-07 18:14:42.0Z
Newsgroups: sybase.public.easerver
From: "Bill Bryant" <bilbryant@yahoo.com>
Subject: Troubleshooting 100%cpu problem with IIS
Date: Tue, 7 Mar 2000 13:14:42 -0500
Lines: 19
Organization: United States Air Force
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 137.245.195.62
Message-ID: <347_EbceSFGi$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26970
Article PK: 154470

Hi,
I was hoping one of you really sharp gurus out there could help me figure
out how to troubleshoot an annoying problem we've been encountering with our
system.

We are running PD3.5 on IISv4 NT4 sp6A and occasionally both cpus in our web
server will max out at a 100% and effectively lock everyone out of the
server. I've been trying to use the IIS exception monitor to help figure
out what web page script is possibly causing the problem, but I'm having
trouble doing that.

Anyone know what registers and stack area I might be able to set the
exception monitor up to look at to try to let me know what script a
particular thread is running?

Bill Bryant
Applied Sciencies Corp


Larry Cermak[Team Sybase] Posted on 2000-03-07 21:53:29.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Troubleshooting 100%cpu problem with IIS
Date: Tue, 7 Mar 2000 15:53:29 -0600
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_jPRnMDIi$GA.285@forums.sybase.com>
References: <347_EbceSFGi$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26942
Article PK: 157893

I ran into a problem yesterday where a PD script was causing cpu to go to
100% for 25 minutes. It was a sql query that needed to be tuned. What's
interesting is that if I ran the same sql statement in isql it returned
almost immediately.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Bill Bryant" <bilbryant@yahoo.com> wrote in message
news:EbceSFGi$GA.202@forums.sybase.com...
> Hi,
> I was hoping one of you really sharp gurus out there could help me figure
> out how to troubleshoot an annoying problem we've been encountering with
our
> system.
>
> We are running PD3.5 on IISv4 NT4 sp6A and occasionally both cpus in our
web
> server will max out at a 100% and effectively lock everyone out of the
> server. I've been trying to use the IIS exception monitor to help figure
> out what web page script is possibly causing the problem, but I'm having
> trouble doing that.
>
> Anyone know what registers and stack area I might be able to set the
> exception monitor up to look at to try to let me know what script a
> particular thread is running?
>
> Bill Bryant
> Applied Sciencies Corp
>
>


Michael F. Nicewarner [TeamSybase] Posted on 2000-03-07 22:50:01.0Z
Newsgroups: sybase.public.easerver
From: "Michael F. Nicewarner [TeamSybase]" <mike.nicewarner@ibpinc.com>
Subject: Re: Troubleshooting 100%cpu problem with IIS
Date: Tue, 7 Mar 2000 16:50:01 -0600
Lines: 69
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: secure.ibpinc.com 198.133.192.2
Message-ID: <347_boeJYgIi$GA.201@forums.sybase.com>
References: <347_EbceSFGi$GA.202@forums.sybase.com> <347_jPRnMDIi$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26936
Article PK: 157887

Yep, I must be "out in front" here. I've been having these kinds of
problems for months now. The query is legitimate, but can be lengthy, and
if the user clicks the "stop" button while it is running, inetinfo goes
"BOOM!" and I have to restart the service. <sigh> I have an open case with
tech support and hope to have something positive to report soon. So far, we
know that the thread going from the web server through Dynamo to the
database is stuck waiting for the query to finish. Other threads from other
browsers should be ok (a bit slow because of the 1st thread). Eventually,
IIS will pick itself up and go back to normal, but it is hell to wait for
it.

My suggestion is to enhance the Query object to support asynchronous mode
queries, with additional methods to let me do things while I'm waiting. The
biggest enhancement I want is the ability to send "partial" information to
the browser. Currently, PD has to finish building the entire page before it
can send back anything to the web server.

--

Michael F. Nicewarner [TeamSybase]
mailto:mike.nicewarner@ibpinc.com
http://www.datamodel.org

Larry Cermak[Team Sybase] <lcermak@ctpartners.com> wrote in message
news:jPRnMDIi$GA.285@forums.sybase.com...
> I ran into a problem yesterday where a PD script was causing cpu to go to
> 100% for 25 minutes. It was a sql query that needed to be tuned. What's
> interesting is that if I ran the same sql statement in isql it returned
> almost immediately.
>
> --
>
> Larry Cermak [Team Sybase]
> Corporate Technology Partners, Inc.
> www.ctpartners.com
> Web DataWindow Articles
> (http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
>
>
> "Bill Bryant" <bilbryant@yahoo.com> wrote in message
> news:EbceSFGi$GA.202@forums.sybase.com...
> > Hi,
> > I was hoping one of you really sharp gurus out there could help me
figure
> > out how to troubleshoot an annoying problem we've been encountering with
> our
> > system.
> >
> > We are running PD3.5 on IISv4 NT4 sp6A and occasionally both cpus in our
> web
> > server will max out at a 100% and effectively lock everyone out of the
> > server. I've been trying to use the IIS exception monitor to help
figure
> > out what web page script is possibly causing the problem, but I'm having
> > trouble doing that.
> >
> > Anyone know what registers and stack area I might be able to set the
> > exception monitor up to look at to try to let me know what script a
> > particular thread is running?
> >
> > Bill Bryant
> > Applied Sciencies Corp
> >
> >
>
>


Jamie Crutchley Posted on 2000-03-07 18:37:25.0Z
Newsgroups: sybase.public.easerver
Reply-To: "Jamie Crutchley" <jdcrutch@raystl.com>
From: "Jamie Crutchley" <jdcrutch@raystl.com>
Subject: Re: Troubleshooting 100%cpu problem with IIS
Date: Tue, 7 Mar 2000 12:37:25 -0600
Lines: 45
Organization: Raytheon
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 128.242.150.59
Message-ID: <347_XlW6PTGi$GA.201@forums.sybase.com>
References: <347_EbceSFGi$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26967
Article PK: 157914

You've probably already gotten this far since you are tyring to track down
what script is running, but we've had the same sort of problem here and were
able to determine that it is almost definately a Dynamo script in an
infinite loop if inetinfo is the process taking all the CPU time. Stopping
the IIS services then restarting them clears it temporarily, but the root
programming error has to be found to do it permanently. The last time this
happened to us, someone had typoed and written

for (i=1; 1 < 4; i++)

instead of

for (i=1; i < 4; i++)

You can see the problem here :) In any case, every time we caught Dynamo
hogging the CPU, it was because we told it to. Good luck tracking that
down. I'd be very interested if there is a way to determine exactly which
script is being run.

"Bill Bryant" <bilbryant@yahoo.com> wrote in message
news:EbceSFGi$GA.202@forums.sybase.com...
> Hi,
> I was hoping one of you really sharp gurus out there could help me figure
> out how to troubleshoot an annoying problem we've been encountering with
our
> system.
>
> We are running PD3.5 on IISv4 NT4 sp6A and occasionally both cpus in our
web
> server will max out at a 100% and effectively lock everyone out of the
> server. I've been trying to use the IIS exception monitor to help figure
> out what web page script is possibly causing the problem, but I'm having
> trouble doing that.
>
> Anyone know what registers and stack area I might be able to set the
> exception monitor up to look at to try to let me know what script a
> particular thread is running?
>
> Bill Bryant
> Applied Sciencies Corp
>
>