KaddypaKhix
New Member
I have a page that makes a stored proc call to a database to return some simple info, real basic stuff. <BR><BR>When I use a local SQL DB it works fine, when I move it to another server with low traffic it works fine. When I move it to a SQL server with lots of traffic I get this message....<BR><BR>-------------<BR>Timeout expired. Possible reasons: the timeout period elapsed prior to completion of the operation, the server is not responding, or the maximum pool size was exceeded. Please see the documentation for further details. <BR>Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <BR><BR>Exception Details: System.Data.SqlClient.SqlException: Timeout expired. Possible reasons: the timeout period elapsed prior to completion of the operation, the server is not responding, or the maximum pool size was exceeded. Please see the documentation for further details<BR>-------------------------<BR><BR>...now, this only happens when the .Net page has to first compile...It's like it compiles then makes the DB hit but because it had to compile first the DB timesout or something.<BR><BR>I am using .Net on a Win2K Advanced Server machine with 4 PII Xeon's and a gig of RAM. Fast machine. The DB is on a fast machine as well but gets hit hard.<BR><BR>I tried adding a timeout=180 to the connection string for the DB in the web.config file but no luck. If I keep refreshing the page eventually it goes through without timing out and once it goes through it will continue to work just fine.<BR><BR>Not sure what else to try. There is another ASP (not .net) app that hits this master DB (5-6 clustered servers) and they hit it just fine. When I move the DB to a test server with little traffic I am fine.<BR><BR>Anyone have any ideas on this? Can someone tell me how to extend the timeout and where to do? What is this Max Pool size?<BR><BR>I am totally lost on this one so any help would be AWESOME!!!<BR><BR>Thanks,<BR>Matt