SQL Time out Exception

Kumar AU

some time I am getting this error in my splunk server, could you please help me, why I am getting this error.

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding

in config file we already have But still we are getting that error in Production, please help me what could be the cause for this.

This is the stack trace info -

The transaction is in doubt.

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The wait operation timed out

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

c# .net

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sonu Gupta6y ago
For more detais visit below article :

https://www.techcartnow.com/increase-timeout-asp-net-application/
Darshan Shah6y ago
Hi,

You may need to check some procedure or something taking too much time to process from the database end which caused timeout.

To check longest running query try below query
SELECT TOP 100
    qs.total_elapsed_time / qs.execution_count / 1000000.0 AS average_seconds,
    qs.total_elapsed_time / 1000000.0 AS total_seconds,
    qs.execution_count,
    SUBSTRING (qt.text,qs.statement_start_offset/2,
         (CASE WHEN qs.statement_end_offset = -1
            THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
          ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) AS individual_query,
    o.name AS object_name,
    DB_NAME(qt.dbid) AS database_name
FROM sys.dm_exec_query_stats qs
    CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt
    LEFT OUTER JOIN sys.objects o ON qt.objectid = o.object_id
WHERE qt.dbid = DB_ID()
ORDER BY average_seconds DESC;
Hope this makes sense!
Amit Gupta6y ago
Add connection timeout in connection string "Data Source=(local);Initial Catalog=AdventureWorks; Integrated Security=SSPI;Connection Timeout=120";