Home / server / Questions / 160972
Accepted
SDReyes
Asked: 2010-07-16 17:08:06 +0800 CST

Tracking SQL Server 2008 Timeout Errors

  • 772

we got some connections timeouts running a stored procedure in a SQL Server 2008 instance. after a while, the DB started to work as usual, and there weren't any additional timeout errors.

So I'm trying to get additional info about the error.

Does SQL server 2008 have any kind of error log that I can look into?

Do exist any auditing/logging features that I can activate to trace the error (if it happens again)?

sql-server logging sql-server-2008 audit

3 Answers

  1. Best Answer

    To see the SQL Logs: Connect to your SQL instance via Management Studio, expand the Management folder in the object browser, expand the SQL Server logs folder and you can examine your logs.

    Default behavior is to keep six logs with a new one being created each time the database engine server is restarted.

    Profiler can always be used to see what is happening under the covers.

    You might post the messages associated with your timeout...

    • 2

  2. SQL Server logs won't capture application timeouts, as they are generated by the client code, not the SQL Server.

    To capture long running queries, you need to use SQL Profiler. Setup a trace which captures all commands which take over 30 seconds (the default .NET timeout) and see what comes up.

    That or put code in the application so that when it gets a timeout it logs some data about the query that it was running, and the failure reason.

    • 1

  3. The currently selected answer is slightly misleading as it discusses referencing the SQL Server Error Log, which will not help for the given scenario.

    As mrdenny quite rightly points out.....

    Application timeouts to SQL Server are initiated from the client-side as Attention Events and are not recorded in the SQL Server Error Log.

    You can monitor for Attention Events using:

    • 0