I have been making changes to an app that has already been released. When I released the new version, SQL server suffered a DeadLock (EventID: 2262). I have tried to replicate this error in the testing environment, but so far have been unsuccessful. On top of this, my app seems to stall (Hang / freeze) after about 5 minutes of use. After further review of my app, I see that when the app freezes, it is freezing on a connection and th only error I get is a timout error. I have changed my connection time out to 500000 to see if it really was a timeout error, but it still did not recover. I am asking if anyone has an idea on hoe to troubleshoot a bug that does not produce a valid error. Also, if anyone knows how to troublshoot a Deadlock error I would like to hear about that too.



Thank you all.