Reputation: 4275
.NET application pool often overflowing. What Should I do for solving this problem? I am using singletton class for db connection. Also; My all db connection lines in using code block. So, it be dispose by .NET engine.
What Should I do for solving this problem?
Upvotes: 0
Views: 251
Reputation: 707
Singleton class for db connection
Does this mean that you only ever have one connection or that the singleton is responsible for creating the connection(s)?
If you just have the one connection, then there is your problem.
Upvotes: 0
Reputation: 616
could you expand on what you are trying to achieve with the singleton, you may not need it if you are using connection pooling in your connection string..?
http://msdn.microsoft.com/en-us/library/8xx3tyca%28VS.80%29.aspx
http://www.15seconds.com/Issue/040830.htm
Upvotes: 0
Reputation: 2119
Upvotes: 1
Reputation: 8568
Make sure objects are properly disposed. Create a mechanism than holds initialized objects and make suze they were disposed after the object is closed.
Upvotes: 0