Commerce Server General - No. of Database connections in a Commerce Server 2002 site

Author

No. of Database connections in a Commerce Server 2002 site

Roshni

2006-06-09, 7:18 am

When we open our Commerce Server 2002 site, there is a minimum of 97
connections that come up when the first user logins into the site. Is that a
default value? Can we change that number of DB connections and does it have
any implications?

Ravi Shankar

2006-06-10, 11:47 am

Nope, it is not a default value. It depend on which all CommerceModules you
choose to activate along with your site. Each of the resources you see under
your site (and ) Profile create DB connections.

This is one of the reasons that SQL Server licensing for Commerce Server is
always Processor based and not CAL based licensing.
--
Ravi Shankar

"Roshni" wrote:

> When we open our Commerce Server 2002 site, there is a minimum of 97
> connections that come up when the first user logins into the site. Is that a
> default value? Can we change that number of DB connections and does it have
> any implications?

Ravi Shankar

2006-06-10, 1:17 pm

Vinayak Tadas[MSFT]

2006-06-19, 2:50 pm

See this KB article
http://www.kbalertz.com/870643/Comm...e.creates.conne
ctions.Server.aspx

Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only

--------------------
Thread-Topic: No. of Database connections in a Commerce Server 2002 site
thread-index: AcaMrX9uL9AeEIsTTk2f3mUWU7ptsg==
X-WBNR-Posting-Host: 59.92.144.49
From: =?Utf-8?B?UmF2aSBTaGFua2Fy?= <shankycheil@newsgroup.nospam>
References: <84CB5DE0-AEA0-4B40-A820-73BB8263AD9C@microsoft.com>
Subject: RE: No. of Database connections in a Commerce Server 2002 site
Date: Sat, 10 Jun 2006 09:47:02 -0700
Lines: 16
Message-ID: <3771A0E5-4DA4-4341-9A67-AC02124BB13B@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17888
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general

Nope, it is not a default value. It depend on which all CommerceModules you
choose to activate along with your site. Each of the resources you see
under
your site (and ) Profile create DB connections.

This is one of the reasons that SQL Server licensing for Commerce Server is
always Processor based and not CAL based licensing.
--
Ravi Shankar

"Roshni" wrote:

> When we open our Commerce Server 2002 site, there is a minimum of 97
> connections that come up when the first user logins into the site. Is
that a
> default value? Can we change that number of DB connections and does it
have
> any implications?

Vinayak Tadas[MSFT]

2006-06-19, 7:19 pm