How To Over come the problem in Time-out Expried

• sqlfriends@sql.com

  SSCommitted

  Points: 1504

  More actions

  October 30, 2009 at 7:26 am

  #216271

  Dear Friends;

  The Problem like I have to Write the sp in Sqlserver 2005 the Sp run around 6min;

  Because The Lot of tables and various database to fetch the records;

  I want to use Asp.net front End to Run the Problem;

  To Throw Error at

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

  How Can i Over come the Problem;

  In Asp.net Configuration To Set sessionTime out in 20min;

  In other way to run the sp in with in 3 min;

  How it;s possible

  Pls help me;

  Thanks advance;

  A.Faijurrahuman

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  October 30, 2009 at 7:45 am

  #1073129

  tune the query to run faster.

• vinoth.krishnamurthy

  Valued Member

  Points: 57

  More actions

  November 2, 2009 at 5:26 am

  #1073765

  Hi,

  optimize the query use some following steps :

  select query from condition joins with (nolock).

  declare table variable in your stored procedure if you have any condtions like groupby or where condition.This will reduce the time of your exection.

  create non-clustered index for maximum required columns.

  use view table with nolock , based on the condition.

  put your procedure in .net CLR integration, this will give better performance to you.

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  November 3, 2009 at 4:45 am

  #1074213

  faijurrahuman17 (10/30/2009)

  ---

  Dear Friends;

  In Asp.net Configuration To Set sessionTime out in 20min;

  That is the Web Session time and has nothing to do with your database connection.

  You have Query Timeout on your Command object and you have connection timeout on your connection object. These needs to be changed.