Modify the DS Database Connection (Pool Size) Configuration

NOTE:  This solution applies to DocuShare 4.x on Microsoft Windows installations only.

The Site Administrator can stop and restart DocuShare and the site will work again for a while, then the above symptom will occur again. An 'invalid state 20' error will be seen in the Event Log.

DocuShare 4.x supports the following SQL Server versions: MSDE 2000, and SQL Server 2000. However, there is also a SQL Server Personal Edition 2000 that might have been installed.

When DocuShare installs to a MSDE 2000 database, the installation software takes in to account this scaled down version of SQL Server and automatically limits the database connections so that the governor that is built in to MSDE by Microsoft will not be overwhelmed.

When DocuShare installs to a full-blown SQL Server version then the software makes use of the greater productivity available with this version of the Database.

When DocuShare installs to the personal edition it 'looks like' a normal SQL Server version to the installation software. Problems then occur because Microsoft has imposed the same governor on this version of SQL Server as it did for MSDE. As a result this version can become overwhelmed by too many connections.

The SQL Server DBA will typically in this situation see a lot of things like: 'This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.'

If necessary, upgrade to the Enterprise version of SQL Server, or try to modify the DocuShare Database configuration. Contact Microsoft support if you need additional assistance.

To modify the Database Configuration to make it more like an MSDE installation:

NOTE: The following must be performed by the DocuShare Server Administrator.

1. Login to DocuShare as Admin
   
2. Click on [Admin Home].  The Admin Home page will be displayed 
   
3. Click on the [+] sign next to Services and Components to expand
   
4. Click on the Database link.  The Database Page will be displayed
   
5. Change the value for the Pool Size from the SQL Server default 15 to the MSDE default of 5
   
6. Click on the [Apply] button at the bottom of the page to apply your settings.

NOTE:  Please refer to the Microsoft website for more information on the SQL Server 2000 workload governor.