Timeout Execution Error in ASP.NET MVC SQL Server 2014

Question

My stored procedure takes 42 seconds to execute . My web application gets timeout after 30 seconds. i have added:

< httpRuntime targetFramework="4.5.1" maxRequestLength="157286400"   
  executionTimeout="36000" />

in my system.web in web.config file. I also added Connect Timeout = 300000 in my connection string of the web.config.

But none of the solutions works for me. I tried to clear the SQL Server deadlock by executing below commands :

exec sp_updatestats

dbcc freeproccache

You need to make sure that Is your server giving you timeout while executing store procedure or your HTTP request is timeout? — Saadi
– Saadi, Commented Apr 5, 2018 at 7:27
did you try to increment commandTimeout for Stored procedure? — user9405863
– user9405863, Commented Apr 5, 2018 at 7:28
Remember that .NET has a different execution plan than SSMS for the same Stored Procedure. Have you tried setting the timeout in your Model.Context.cs? Try doing this, stackoverflow.com/questions/10549640/… — mvisser
– mvisser, Commented Apr 5, 2018 at 8:25

Shiba Das · Accepted Answer · 2025-04-13 08:27:42Z

0

By default, many frameworks set the command timeout to 30 seconds, so if your query takes around 40 seconds, it'll run fine in SSMS but not in code. for EF

            context.Db.Database.CommandTimeout = 60; // Timeout in seconds

            var sqlQuery = @"exec spRunt ";

            return context.Db.Database
                .SqlQuery<DataType>(sqlQuery)
                .ToList();

For Ado

 SqlCommand command = new SqlCommand(query, connection);
command.CommandTimeout = 60; // Timeout in seconds

answered Apr 13 at 8:27

Shiba Das

3675 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Timeout Execution Error in ASP.NET MVC SQL Server 2014

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related