Thank you Very much!!!
Couple of follow up questions:
Is 2G hard set as the limit to the amout of virtual memory IIS can use?
Is there anyway to change this? Same question for Commerce?
I will continue to try and monitor this with Perfmon and let you know my
findings.

"Vinod Kumar[MSFT]" wrote:

> CAUSE
> =====
>
>
> The system may be configured with a large quantity of physical memory. Too
ls such as Task Manager and Performance Monitor may indicate that a large po
rtion of that memory is available. For example, if the
> system is configured with four gigabytes of physical memory, less than one
 gigabyte of this memory may be in use. However, if the virtual memory for t
he Internet Information Services (IIS) DLLHost process for
> Medium Isolation mode approaches two gigabytes, problems start to occur. E
ven if the server has large memory resources that are available to the syste
m, the virtual memory of the IIS process may become
> fragmented. Various errors may be reported, indicating that memory resourc
es have been used up.
>
>
>
> The Commerce Server OLE DB provider typically uses the SQL OLE DB provider
 to perform database operations. In a large E-Commerce site, the Commerce Pr
ofile services must continually retrieve data from
> the SQL database. The SQL OLE DB provider tries to allocate large contiguo
us blocks on demand to perform these operations. These allocations are perfo
rmed in the virtual memory address space of the IIS
> process. If this process is approaching the process limit for virtual memo
ry that is established by Microsoft Windows 2000, errors result. If no block
s of contiguous virtual memory are available because of
> fragmentation, the application may return error messages indicating that n
o memory is available.
>
>
>
> RESOLUTION
> ==========
>
>
>
> To alleviate these symptoms, the system must be configured to prevent each
 IIS process from using up the virtual memory that is available. By default,
 Windows 2000 with IIS 5.0 is configured in Medium Isolation
> mode. In this configuration, the Commerce 2000 and Web site code use a sha
red DLLHost process. Use Performance Monitor to make sure that the virtual m
emory for this process does not approach two
> gigabytes.
>
> Thanks
> -Vinod
>
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> You assume all risk for your use. © 2002 Microsoft Corporation. All right
s
> reserved.
> --------------------
> From: "AD" <allan.dempsey@gmail.com>
> Newsgroups: microsoft.public.commerceserver.general
> Subject: Not enough memory to allocate buffer for SQL statements. Catalog:
 Profile Definitions
> Date: 14 Jul 2005 20:26:09 -0700
> Organization: http://groups.google.com
> Lines: 25
> Message-ID: <1121397969.946483.63330@g14g2000cwa.googlegroups.com>
> NNTP-Posting-Host: 66.190.67.16
> Mime-Version: 1.0
> Content-Type: text/plain; charset="iso-8859-1"
> X-Trace: posting.google.com 1121397975 9996 127.0.0.1 (15 Jul 2005 03:26:1
5 GMT)
> X-Complaints-To: groups-abuse@google.com
> NNTP-Posting-Date: Fri, 15 Jul 2005 03:26:15 +0000 (UTC)
> User-Agent: G2/0.2
> Complaints-To: groups-abuse@google.com
> Injection-Info: g14g2000cwa.googlegroups.com; posting-host=66.190.67.16;
>    posting- account=W6BrmA0AAACqBvvnyLqovDOtBGleRVJ3

> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.d
e!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news
.prodigy.com!
> newscon02.news.prodigy.com!prodigy.net!news.glorb.com!postnews.google.com!
g14g2000cwa.googlegroups.com!not-for-mail
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3022
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> I get these errors several times a day. I can not find any usefull
> information on these errors. I need to find out what this means, a
> probable cause and possibly a resolution to it.
> It is followed by several other errors.
>
> Event ID: 32784
> Not enough memory to allocate buffer for SQL statements.  Catalog:
> Profile Definitions
>
> Event ID: 32785
> Could not create the catalog (-2147024882)
>
> Event ID: 32773
> DataSource::Init(DS-1237-Profile Definitions) failed on catalog load
> (-2147024882)
>
> Event ID: 32769
> In BindArgs::OpenDataSrc(), failed initializing data source
> (-2147024882)
>
> Event ID: 14
>
> Thanks in advance!
> AD
>
>
>

[ Post a follow-up to this message ]