I have a website that randomly grinds to a halt. At first I thought this was due to the number of users in the system and database connections being left open but when it occurred today I ignored the database server and simply stopped IIS, killed the w3wp.exe processes (There were a number of them), started IIS and everything was back to normal.
There were/are around 17 w3wp.exe processes all using between 200,000K and 400,000K which seems like a lot to me. But the web server wasn't running out of memory, we have 24 gig of which 7 was being used. The CPU also appeared fine.
At the moment the system isn't under load and the w3wp.exe processes are hitting around 150,000K to 200,000K.
Any ideas as to what the problem could be?