KB00012 - Full SQL Connection Pool

In this article:

Adjusting Web.Config

You will find the Web.Config file in

C:\inetpub\wwwroot\[TreonWesite].

Please open the file in a text editor and search for the section “<appSettings>”.

../../_images/image0019.png

Silver Monkey connects to at least two different SQL databases:

  • Its original Silvermonkey SQL database
  • The SCCM Site database

Depending on which Connection Pool fills up first, either TreonConnectionString* or SiteConnectionString* will have to be adjusted. Especially, pay attention to the last part of the Connection String:

../../_images/image0039.png

You will have to add the following code or rather adjust its value to “500” if it doesn’t already exist in the Connection String (the value is set to “100” by default):

;max pool size=500

Both Connection Strings, *SQL as well as *Windows have to be changed.

For further Information about Connection String, please visit this website .