Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Oct 20 '11 at 10:46

This question came from our site for professional and enthusiast programmers.

    
See Waits and Queues –  Martin Smith Oct 18 '11 at 21:10

2 Answers 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

share|improve this answer
    
no, I'll look into it. Thanks –  NullReference Oct 18 '11 at 22:40
up vote 0 down vote accepted

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

share|improve this answer
    
Thanks for sharing your answer with us even if it was "one of those" –  Jack Douglas Oct 24 '11 at 17:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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