IIS 5 getting terminated unexpectedly

[attinder]

I am using IIS 5, which is running on windows 2000. And i am running a intranet based side which is using sql server 7 running on another server with winnt 4

This site was running fine for last one year on winnt with IIS 4. I switched to IIS 5 4 months back. Still it was running but for last 1 week it started getting teminated unexpectedly. I am trying to get all possible problems. But enable to .

[txbakers]

Sometimes a bad SQL statement will cause IIS to shut down. I don't know why. It's a Microsoft thing.

You can set the service to restart automatically if it fails in 2000. Couldn't do that in NT4.

[attinder]

I am doing that, service gets restarted if it is terminated. But problem is session gets clear and all the users has to start from the login.

I check all of my sql commands too. They are working fine in winnt4 but i dont know why they are failing under windows 2000

[joshie76]

Sometimes a bad SQL statement will cause IIS to shut down.

Crikey, I've never ever seen that and I've written some awful SQL statements;)

What's in your server's event logs attinder?

[attinder]

Every time it mark event with out of memory for active server pages. And these pages are not fixed.

Event says same for error page 500

[joshie76]

Sorry attinder, is that whats in your actual server event logs (aystem¦application) not IIS logs? (You'll find the event viewer at Start > Administrative Tools > Event Viewer)

[attinder]

Yes its in my system¦application event log

[txbakers]

out of memory for active server pages

That explains it perfectly.

Something in your code is causing either an infinite loop, or bad logic is causing your pages to hang and eat up memory. Eventually IIS just gives up and shuts down.

[benfer]

Sounds to me as if your database connections are not closing properly. Make sure you set each connection to close AND to nothing. Like this (of course enclosed in asp tags):

databaseName.close
set databaseName = nothing

Could also be any other object created within a page not set to nothing. HTH.

dmb

[attinder]

Hi, ALL, thanx for help, but i am following best practices of ASP religiously. So I am closing database connections and setting all objects to nothing.
Even i didnt find any of mine codes going in infinite loop.
Still i am checking my pages. I got around 100 ASP pages. So i think it will take time for me to review them