I am running a web application having 500-600 users at a particular time on sql 2000 and ASP.NET 2005.
generally it works ok but suddenly it goes down. when i check progress tab of Task Manager it shows 0 % CPU usage.
when i restart sql service (through SQL Agent) then software begins running normally.
i don't know why this is happening.
pls guide me to come out of this problem.