We use SQL Server 2008 for our database. We use a combination of Classic ASP and .NET to connect to said database. We get random timeouts on queries that are extremely simple and when we run said queries they appear to be quick and have the correct indexes.

What I'm wondering is if there is a way to have SQL Server gather/keep data on these timeouts and send it to us. I've read in the past that you can do this for deadlocks.


2 Answers 2


Perhaps (at least some of) these "random timeouts" might be network related?

You should definitely consider performance monitor. You can view statistics in real time, collect statistics to generate a baseline, and configure triggers to send alerts.

PS: Here's a good link to get you started:

Free Microsoft Tools to Help Setup and Maintain PerfMon for SQL Server


It might be worth your while to check all activity on the server, not just what you are sending it.

Read about SQL Server Profiler on StackOverflow and Microsoft

There may be external factors affecting this as well, and getting your DBA / System Admin involved may be a good idea.

  • There really isn't a so much of a DBA to speak of. I know about and use Profiler, but don't know how to use it effectively in this case.
    – Grummle
    Nov 1, 2011 at 16:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.