• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

SQL Server Intermittent Timeouts

Hello Experts,

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.

1 Solution
Did you get a chance to check the event view logs, windows system logs?

Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<Can you please advice how to troubleshoot what caused this.>>
> After making sure that both the API and server timeouts settings are high, check if the problem perdures.  If it does, chances are the procedures times out because of a network failure
> If the problem does not perdure, set up a trace to identify timeouts.  Server side timeouts are by definition processes that start but never complete.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now