Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Oct 29 '11 at 14:13

This question came from our site for professional and enthusiast programmers.

    
Might be worth seeing this answer. –  Marian Nov 2 '11 at 13:29

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

share|improve this answer

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.

share|improve this answer
    
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 '11 at 16:56

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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