w3wp use a lot of memory and the site stop

[hihai]

My site recently became not responsive. When I check the task manager, I saw the file w3wp.exe use a lot of memory. Then I reset the IIS, it runs ok but only for a while then it stops. At first, I thought the server was not configed appropriately but when I check the html files or other pages that don't connect to SQL, it still runs.

Two days ago, the site stops when the file w3wp.exe use about 500MB. But today the site stops when it uses only 270MB.

My site use ASP.NET, OS 2k3. Could any one help me figure out why this happen?

[Frinavale]

My site recently became not responsive. When I check the task manager, I saw the file w3wp.exe use a lot of memory. Then I reset the IIS, it runs ok but only for a while then it stops. At first, I thought the server was not configed appropriately but when I check the html files or other pages that don't connect to SQL, it still runs.

Two days ago, the site stops when the file w3wp.exe use about 500MB. But today the site stops when it uses only 270MB.

My site use ASP.NET, OS 2k3. Could any one help me figure out why this happen?

I've read that w3wp.exe does take up a lot of resources but I don't know what the normal type of activity for your SQL server would be.

Check your Windows Event Logs to see if there are any errors related to the problem listed there

Check to make sure that you've closed all of your SQL connections in your coding as well.....just to be safe.

-Frinny

[Motoma]

Welcome to theScripts!
It is unlikely that you server is crashing because of the memory that the processis is taking, rather, it sounds like something is causing the application pool to crash. Check your event log to see if this is the case.

[hihai]

Thank you for your guide. When I check in the event log, there was no application pool error. I think the application pool is ok because all other pages that are not connected with SQL still run well at anytime.

I guess there may be connection errors or something like that. But I don't know how to test the connection errors. Could you tell me more about this?

[Motoma]

Try setting up some breakpoints and watches, then step through your code.

Thank you for your guide. When I check in the event log, there was no application pool error. I think the application pool is ok because all other pages that are not connected with SQL still run well at anytime.

I guess there may be connection errors or something like that. But I don't know how to test the connection errors. Could you tell me more about this?

[Frinavale]

Thank you for your guide. When I check in the event log, there was no application pool error. I think the application pool is ok because all other pages that are not connected with SQL still run well at anytime.

I guess there may be connection errors or something like that. But I don't know how to test the connection errors. Could you tell me more about this?

Normally when you get a connection error an exception is thrown.
Are you catching all of your exceptions? Maybe try either removing the catches or when you catch such an error record it in some way.

-Frinny