Debugging a database deadlock

JerryClask

New Member
I am trying to solve a problem with a site written in classic ASP with a SQL Server 2000 database.Every few days the site seems to go down. There is no response from the website, when you try to visit it. The loading indicator in your browser will spin round, but nothing happens, your browser just stays blank.I can get the site working again by killing all the processes in the database.I can't work out what's going on. There seems to a be database deadlock. Any ideas of what could be causing it, or how I can stop it from happening?
 
Back
Top