SP-C Pooled Database Connections How many Connections MailSite SP-C pools on a MS SQL Server Database? 1. Every service that is running uses a maximum of 16 (Default) pooled connections to the DB. 2. If you are running the MailSite GUI, it will also create pooled connection up to a max of 16(Default) pooled connections. 3. If you are also connecting other MailSite servers to that DB they will also create a max of 16(Default) pooled connections to the DB per running service and MailSite GUI. To Change the Default values you will need to edit the registry. WARNING!! Incorrectly editing the registry can damage the server, please be sure you know what you are doing 1. Click on the Start button 2. Select the RUN option 3. Type regedit, the registry editor will open 4. Select the HKEY_LOCAL_MACHINE\Software\Rockliffe\Mailsite\SqlConnector key 5. Add a REG_DWORD entry rename it to: ConnectionLimit 6. Set this entry to decimal and enter the value of that you want to reduce or increase the Pool by. (default is 16) 7. This will need to be applied to all servers that have a MailSite Service running on it.