Expanding Max Pool Size to raise the number of SQL connections
Dakota_Green
Member Advanced IT Monkey ✭✭✭
Hello Community!
Microsoft SQL Server has a set threshold of connections that can take from the connection pool. This is not very helpful if you have a huge Help Desk, or if SQL Server/asp.net is not closing any of those connections. It may manifest itself as the following error in the Web Console log:
System.InvalidOperationException: 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.
To work around this, we can add a Max Pool Size to your Web.Config file. We recommend starting at 300, and then working your way up depending on load.
To accomplish, do the following:
1. On the Portal server, navigate to C:\inetpub\CiresonPortal (or wherever you installed the Cireson Portal at)
2. Locate the file "Web.config" and then open in a text editor (Notepad should do the trick)
3. Locate the following line:
<add name="ServiceManagementDatabase" connectionString="Server=(DOMAIN NAME);Database=ServiceManagement;Trusted_Connection=True;" />
At the end of
Trusted_Connection=True;
add the following:
Max Pool Size=300;
The line should now look like this:
<add name="ServiceManagementDatabase" connectionString="Server=(DOMAIN NAME);Database=ServiceManagement;Trusted_Connection=True;Max Pool Size=300;" />
I am currently drafting a Knowledge Base article that will include details on some of the most common errors that come up in both the Cache Builder and Web Console log files. This will be included in the article.
Hopefully this helps!
Microsoft SQL Server has a set threshold of connections that can take from the connection pool. This is not very helpful if you have a huge Help Desk, or if SQL Server/asp.net is not closing any of those connections. It may manifest itself as the following error in the Web Console log:
System.InvalidOperationException: 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.
To work around this, we can add a Max Pool Size to your Web.Config file. We recommend starting at 300, and then working your way up depending on load.
To accomplish, do the following:
1. On the Portal server, navigate to C:\inetpub\CiresonPortal (or wherever you installed the Cireson Portal at)
2. Locate the file "Web.config" and then open in a text editor (Notepad should do the trick)
3. Locate the following line:
<add name="ServiceManagementDatabase" connectionString="Server=(DOMAIN NAME);Database=ServiceManagement;Trusted_Connection=True;" />
At the end of
Trusted_Connection=True;
add the following:
Max Pool Size=300;
The line should now look like this:
<add name="ServiceManagementDatabase" connectionString="Server=(DOMAIN NAME);Database=ServiceManagement;Trusted_Connection=True;Max Pool Size=300;" />
I am currently drafting a Knowledge Base article that will include details on some of the most common errors that come up in both the Cache Builder and Web Console log files. This will be included in the article.
Hopefully this helps!
2
Comments
normally this setting only needs to be modified if the code is not written correct. If all the sessions are closed correct, the standard settings should be OK. We had this error with 10 people working on the portal after upgrading to 6.0.2.
Please referr to these articeles and review your code:
https://blogs.msdn.microsoft.com/spike/2008/08/25/timeout-expired-the-timeout-period-elapsed-prior-to-obtaining-a-connection-from-the-pool/
https://blogs.msdn.microsoft.com/angelsb/2004/08/25/connection-pooling-and-the-timeout-expired-exception-faq/
KR
We are looking into possible causes for this and will address any code changes that are needed.
Thank you for your feedback.
Carrie
The latest release Portal v7.0 resolves this issue.
You can update to the latest version using your ClickOnce application or download from: http://softwaredownloads.cireson.com/
Please review the release notes here: https://support.cireson.com/KnowledgeBase/View/1351#/
Please let us know if you have any questions.
Thank you,
Carrie