
January 10th, 2005, 11:24 AM
|
|
Registered User
|
|
Join Date: Nov 2004
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SQL Server Deadlock / Vb.NET app
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.
|