Time out in SQL Server Query Processing

• Dilip Nagle

  Old Hand

  Points: 340

  More actions

  May 21, 2006 at 9:51 am

  #103166

  Sub: My Question falls in the region of asp.net/VB.net and backend SQL 2000 Server

  1. I create a Dataset in asp.net/VB.net.

  2. Then, I call a stored Procedure (fully functional and working when run through Query Analyser) that returns a result set . The stored procedure takes Closing balances of previous year ending and adds up current year's transactions in to return Op.Bal, In, Out and Cl.Bal. - Itemwise.

  It is a data processing that involves about 100,000 records.

  3. The problem - When I run this through my application's web page , in Try Catch routine, it gives me an Application Time out has occured.

  4. I have ensured that my web page has 100 minutes of timeout as against default 20 min.

  5. When, I run this web page from the Server where my SQL Database is, sometimes I get reult in a minute.

  6. I do not understand as to what do I need to do to overcome this problem.

  7. The Server hardware configuration is Intel SE 7221 Server motherboard, 4GB of DDR2 RAM 2 x 160GB HDD with MS Win 2003 Server O/s, dot net framework 1.1 and SQL 2000 Server running on it.

   

  Kindly help.

   

  Dilip Nagle

   

• satz

  SSC Veteran

  Points: 231

  More actions

  May 22, 2006 at 6:14 am

  #639204

  what is the command timeout?

• Dilip Nagle

  Old Hand

  Points: 340

  More actions

  May 24, 2006 at 6:39 am

  #639739

  Dear Grasshopper,

  Where Do I set Command Timeout?

   

  Reagrds,

  Dilip Nagle