Connection timeout on initial Load of ASP.NET web app

• Mason-439007

  SSC Rookie

  Points: 47

  More actions

  May 22, 2007 at 1:18 pm

  #179003

  Hello,

  We've built a new large ASP.NET web application. On our staging servers there are no timeout issues or connectivity problems. When we moved to the production server, which is a MUCH faster server machine with 2-dual core CPU's. What is happening is there is a SQL timeout issue usually only on the first load of the page. After it loads once, it doesn't seem as slow or have as many time-out issues.

  I know the connection string is correct. The Max Connections is set to unlimited. Yes, we have our normal live-website still running in parallel but the CPU on both the Web & Db servers are as normal as ever.

  Does anyone have any ideas as to why I am able to connect to the server sometimes and other times not at all? I am certain it's not an issue with a bad query as these procedures run very fast when tested in production through Query Analyzer.