Re: I keep getting this error when i send a large document into sql server with ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough storage is available to complete this operation. I have about 8 gigs of memory on the machine and sql

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 09/24/05 

Date: Sat, 24 Sep 2005 15:55:08 +0100

Please do not multipost there are separate replies in:
microsoft.public.sqlserver.xml
microsoft.public.sqlserver.programming

John

"Daniel" <softwareengineer98037@yahoo.com> wrote in message
news:%23CVd4aHwFHA.2212@TK2MSFTNGP15.phx.gbl...
>I keep getting this error when i send a large document into sql server with
> ADO.NET System.Data.SqlClient.SqlException: XML parsing error: Not enough
> storage is available to complete this operation. I have about 8 gigs of
> memory on the machine and sql server isnt using even half of it. any way
> to
> configure sql server to use more of the memory?
>
>

Relevant Pages

  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FTS Performance in SQL 2005
    ... we had no end of problems with SQL FTS. ... Looking for a SQL Server replication book? ... The Memory Usage and VM Size never increase over about 65 MB and 20MB. ... cost relative to the whole batch, ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Consolidating instances of SQL server
    ... SQL Server is designed to use memory. ... The maximum amount of memory SQL Server can use varies depending on your ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: The DBMS returned an unspecified error.
    ... | We are using Microsoft's JDBC driver for Java database access to SQL ... | Insufficient memory available. ... even though SQL Server 2000 is configured to use up to the ... the problem is most likely in the MemToLeave ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: multiple instances of sql - 2 Gb memory limitation?
    ... The 2GB Memory limitation is per instance and the SQL Server can be ... Configure memory for more than 2 GB in SQL Server ... Microsoft Windows 2000 Advanced Server or Microsoft Windows 2000 Datacenter ...
    (microsoft.public.sqlserver.server)