The Commerce Server 2002 Profile Service creates many connections to SQL Server (870643)


The information in this article applies to:

  • Microsoft Commerce Server 2002

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 "Resolution" 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
Modification Type:MajorLast Reviewed:7/14/2004
Keywords:kbprb KB870643 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.