SQL Server Intermittent Timeouts
Posted on 2010-11-10
There were intermittent sql server timeouts for the end users hitting the API's on the app server.
I have checked all the logs and did not find any reason.
There was no resource contention at that time (Cpu, memory etc).
Can you please advice how to troubleshoot what caused this.
Will I be able to use SQL Profiler Lock:Timeout (timeout > 0) Event Class or any other event class to capture this.
We are on SQL 2005 Ent Edition on Win2K3.