March 4, 2016 at 11:49 am
I am trying to research an issue with an application timing out when it tries to connect to a SQL database. I decided to run profiler (I am no expert). I am getting results of "Lock:Timeout" for the database. The duration column is showing "0". I was thinking the timeout would occur after a period of time waiting. I am also logging Deadlocks... but none have occurred. Can anyone shed light on this for me. Thank you in advance.
Charlie
March 4, 2016 at 4:06 pm
You can start from posting an actual error message you are getting from application.
March 29, 2016 at 11:42 am
Set up the profiler to catch events(login, tsql, sp et al) created by the application user. Track each of the activity of the user & determine at what step the timeout occurs. It need not be at the database level, sometimes connection strings have a time limit & if your query runs longer, the timeout error occurs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply