07-24-05 10:50 PM
CAUSE
=====
The system may be configured with a large quantity of physical memory. Tools
such as Task Manager and Performance Monitor may indicate that a large port
ion of that memory is available. For example, if the
system is configured with four gigabytes of physical memory, less than one g
igabyte of this memory may be in use. However, if the virtual memory for the
Internet Information Services (IIS) DLLHost process for
Medium Isolation mode approaches two gigabytes, problems start to occur. Eve
n if the server has large memory resources that are available to the system,
the virtual memory of the IIS process may become
fragmented. Various errors may be reported, indicating that memory resources
have been used up.
The Commerce Server OLE DB provider typically uses the SQL OLE DB provider t
o perform database operations. In a large E-Commerce site, the Commerce Prof
ile services must continually retrieve data from
the SQL database. The SQL OLE DB provider tries to allocate large contiguous
blocks on demand to perform these operations. These allocations are perform
ed in the virtual memory address space of the IIS
process. If this process is approaching the process limit for virtual memory
that is established by Microsoft Windows 2000, errors result. If no blocks
of contiguous virtual memory are available because of
fragmentation, the application may return error messages indicating that no
memory is available.
RESOLUTION
==========
To alleviate these symptoms, the system must be configured to prevent each I
IS process from using up the virtual memory that is available. By default, W
indows 2000 with IIS 5.0 is configured in Medium Isolation
mode. In this configuration, the Commerce 2000 and Web site code use a share
d DLLHost process. Use Performance Monitor to make sure that the virtual mem
ory 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 rights
reserved.
--------------------
From: "AD" <allan.dempsey@gmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Not enough memory to allocate buffer for SQL statements. Catalog: P
rofile 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:15
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.de!
t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!newscon06.news.p
rodigy.com!
newscon02.news.prodigy.com!prodigy.net!news.glorb.com!postnews.google.com!g1
4g2000cwa.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 ]
| 
