| David Messner [MSFT] 2005-08-02, 6:03 pm |
| Allan
Can you make sure that you're not creating ProfileContext (.NET) or
ProfileService (COM) objects anywhere in your application other than at
startup?
Typically this problem would be solved by creating one ProfileContext
object for the site (which is done automatically for you with the
CommerceProfileModule if you are using it) and re-using that ProfileContext
object throughout the site. If you are creating them on a per-request
basis, bad things like this will happen - ProfileContext/ProfileService is
an exceptionally expensive object to create because it reads in the entire
profile definition catalog and creates large caches and connection pools.
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.
Subject: RE: Not enough memory to allocate buffer for SQL statements. Catal
Date: Wed, 27 Jul 2005 11:11:02 -0700
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.
Tools such as Task Manager and Performance Monitor may indicate that a
large portion 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 the Internet Information Services (IIS) DLLHost process for
> Medium Isolation mode approaches two gigabytes, problems start to occur.
Even 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 to perform database operations. In a large E-Commerce site, the
Commerce Profile 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 performed 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 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
shared DLLHost process. Use Performance Monitor to make sure that the
virtual memory 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: 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: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-onli
ne.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!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
>
>
>
|