1

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

1
2

Have you tried polling for dbcc opentran? It could be you have an uncommitted transaction problem occurring on that database. Also, worth checking the collation of the databases is the same, always the first thing to check in a "this one works this one dosent" scenario

http://msdn.microsoft.com/en-us/library/ms182792.aspx

0
0

Ended up rebuilding the database from script and the problem went away.

1
  • Thanks for sharing your answer with us even if it was "one of those" Oct 24 '11 at 17:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.