AP.NET Process Recycling

kailux4

unread,

Jul 17, 2006, 1:19:01 AM7/17/06

to

Hi,

I am calling a web service which in turns call another web service which
does sql inset to SQL Server database.

i have process recycling on the 2nd web service, which talks to sql server.
some time calls to sql server from 2nd web service takes longer than process
shut down time (setting for recycling) hence the current request gets
terminated by the worker process when recycling happens, thats fine but the
error that i get when this happens is SQL time out, which i doesnt get if i
uncheck the recycling setting as there is suffcient high command and query
time out

my question is, why does i get SQL time out error when the process gets
recycles terminating current request ?

Thanks

Steve Schofield

unread,

Jul 17, 2006, 10:39:53 PM7/17/06

to

Here is an article that explains how "Worker process recycling works"
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/24e3c22e-79a9-4f07-a407-dbd0e7f35432.mspx?mfr=true
--

Steve Schofield
Windows Server MVP - IIS
ASPInsider Member - MCP

http://www.orcsweb.com/
Managed Complex Hosting
#1 in Service and Support

"kailux4" <kai...@discussions.microsoft.com> wrote in message
news:37C1393C-78FC-4B0F...@microsoft.com...

kailux4

unread,

Jul 18, 2006, 12:24:01 AM7/18/06

to

That is fine,
but what error does it throws to client when process gets shut down and
terminate current the current incompleted requests

Trevor Benedict R

unread,

Jul 18, 2006, 9:04:01 PM7/18/06

to

We'll the Current processes that are executing should complete normally and
the new ones will be executed under the context of the new process. It is
not something like End & Start. Actually they overlap. Did you read the
article that Steve posted.

Regards,

Trevor Benedict R

"kailux4" <kai...@discussions.microsoft.com> wrote in message

news:11F03D79-A839-4743...@microsoft.com...

kailux4

unread,

Jul 18, 2006, 11:58:01 PM7/18/06

to

Hello Trevor,
thaks for that but
i have gone thru the article, my question is when a process recycles, old
process will try to complete all currently executing request within the shut
down time limits and new request will be taken care by new process once its
is initialized.. ok , now there is a possiblity that some requests in old
process might not gets completed withing shut down time limit and thus old
process would terminate all such request ... i just want to know when a
request gets terminated by old a process what error does the client gets?

i am always getting sql time out

Thanks

Steve Schofield

unread,

Jul 19, 2006, 5:18:08 PM7/19/06

to

I am not sure what the error you will see. The only way to see the behavior
on the client is setup an environment and try to reproduce this behavior.
Test, Test, Test...:)

--

Steve Schofield
Windows Server MVP - IIS
ASPInsider Member - MCP

http://www.orcsweb.com/
Managed Complex Hosting
#1 in Service and Support

"kailux4" <kai...@discussions.microsoft.com> wrote in message

news:3DD32CF2-E569-4876...@microsoft.com...

Trevor Benedict R

unread,

Jul 21, 2006, 6:48:28 PM7/21/06

to

Should be something in the line of Script Timeout.

You can write a small script with a For loop that goes on for about 2/3
minutes and then set the Process shutdown and recycle options to shutdown
before this and see what happens.

Regards,

Trevor Benedict R

"kailux4" <kai...@discussions.microsoft.com> wrote in message

news:3DD32CF2-E569-4876...@microsoft.com...