----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Gadadahar Message 1 in Discussion Hello, In our application developed in .net2.0 and SQLServer2005 we have a windows scheduler service which will call a C# assembly in multiple threads around 200 times at the same time. Each thread will import a file and update 200 separate instances of the database (all on one Database server). We are logging the sequence of events that is happening. After some opening connection with some 80 + databases, it throws error that "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Once this error is thrown, a sequence of "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." After a gap of around 2 minutes again it could establish the connection and will start importing and updating the database. After processing few the above mentioned sequence of error repeats. If my understanding is correct, connection pooling won't come in to picture here because connections are different since the dll is connecting to 200 different databases. All opened connections are very well closed in the application. Is it becuase there setting for the number of connetions that one SQL Server instalaltion can accept (max I think is 32,767).This is happening on the live server and we are not able to simulate the scenario in our test bench. Any help will be appreciated ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
