I'm trying to troubleshoot a timeout issue that occurs on one of our SQL 2005 servers.
The database responds normally for about a day until we start to see sql timeout errors. After that all queries take 30+ seconds to return and it does not return to normal operation until we reset the SQL services. The sql queries are very simple, updating a single row in a database.
It seems like the problem is specific to one database because we can run the same queries on another database on the same server and they return normally. I've looked into possible locks using the technique outlined here and I don't see anything that sticks out. This is on one of our beta servers so there are very few requests to it. Any ideas? Thanks