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.