I have a .NET application written in C# and ASP.NET (VS 2005). The
Database is SQL Server 2005. I have several SPs executed from the ASP
pages and all seems to work well. However, I have one SP that supplies
an error "Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding." The SP
executes(in QueryAnalyzer) in 32 seconds. The ASP page is timing out. I
have the connection String Connect Timeout = 1000 and the ASP
Server.Timeout = 1000. I have also verified the Remote Procedure Call
in SQL server is set = 600, seconds. I have tuned the SP to only read
necessay rows (by date) ~600K for a month. I narrow the results from
there to return counts of who is in each state specified. This, I
thought, would allow the results to be returned. If I look at a time
span of 2-3 days it does return results, anything greater provided a
timeout. The ASP page continues to timeout in 30 seconds, although, on
the Development box works fine (the development box is a smaller
version of production, not as much data).

CAN Anyone provide a suggestion won what might be the issue?

Simple Query Notification - Doesn't Work!!
Retrieve GUID on/after insert?
Closing Connections
Re: Connection to ORACLE: Need some explanations
Connection to ORACLE: Need some explanations