Microsoft KB Archive/870643

= The Commerce Server 2002 Profile Service creates many connections to SQL Server =

Article ID: 870643

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



SYMPTOMS
The Microsoft Commerce Server 2002 Profile Service may make manyconnections to your Microsoft SQL Server database.



CAUSE
This behavior occurs because the Commerce Server 2002 Profile Service creates approximately 92 connections to the SQL Server database. In most cases these connections are minimal.



RESOLUTION
To reduce the number of connecions that are used by the Commerce Server 2002 Profile Service, set an environment variable. To do this, follow these steps:
 * 1) In Control Panel, open System.
 * 2) On the Advanced tab, click Environment Variables.
 * 3) Under System variables, click New.
 * 4) In the Variable name box, type MaximumDBConnections.
 * 5) Type a number that is less than 92, such as 10, in the Variable value box, and then click OK.



STATUS
This behavior is by design.



MORE INFORMATION
The MaximumDBConnections system variable that you created in the &quot;Resolution&quot; section controls the number of connections that the Commerce Server 2002 Profile Service creates.

Make sure that you adequately test your environment before you put these changes in a production environment. Microsoft has tested these settings with positive results.

Note The Commerce Server 2002 Profile Services uses the following formula to determine the number of connections to create in the pool during initialization:

(MaxiumumDBConnections * 3 + 1)

For example, if the MaximumDBConnections system variable is 5, the number of connections is 16. (5 * 3) + 1 = 16

Keywords: kbprb KB870643

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.