Re: Memory issue

From: James (jamestthomas_at_comcast.net)
Date: 10/07/03 

Date: Tue, 07 Oct 2003 15:17:25 GMT

Can you post a complete example of your call to the database. Are you
connection pooling? Are you releasing connections back into the pool or is
the pool growing too large? Are you manipulating arrays - any dangling
references? The data coming back - is it huge? Are any result sets hanging
around? Just a few questions that may spark something.

"Frank Brouwer" <frank.brouwer@trimergo.nl> wrote in message
news:3f819c9c$0$445$1b62eedf@news.wanadoo.nl...
> Hi All,
>
> I have a problem with memory when I use a connection to a database. I
have
> also posted the question in the database group but as I suspect that it
has
> to do with garbage collection I also post the question here.
>
> I have a problem with memory using SQLserver on a server running WIN2K
> Advanced Server with 2 GB! of internal memory. We limmited the SQLserver
> memory to 1 GB and 512 MB for JVM (version 1.4.2_01). The OutOfMemory
error
> is always at the same place in the jdbc driver as shown below.
>
> java.lang.OutOfMemoryError
> at com.microsoft.util.UtilPagedTempBuffer.compressBlockList(Unknown
Source)
> at com.microsoft.util.UtilPagedTempBuffer.getBlock(Unknown Source)
> at com.microsoft.util.UtilPagedTempBuffer.write(Unknown Source)
> at com.microsoft.util.UtilPagedTempBuffer.write(Unknown Source)
> at com.microsoft.util.UtilByteArrayDataProvider.receive(Unknown Source)
> at com.microsoft.util.UtilByteOrderedDataReader.receive(Unknown Source)
> at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown
> Source)
> at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown
> Source)
> at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
> Source)
> at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
> at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
> Source)
> at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown
> Source)
> .............................................. Truncated from here
> .................................................
>
> If I run (using same database & JVM) on a computer (W2K prof.) with 512 MB
> internal memory and no limmit set for MS-Sqlserver but for JVM 128 MB
doing
> the same stuff, there is no problem at all.
>
> I suspect it has something to do with a late "kicking in" of the Garbage
> Collection causing memory segmentation. So when a big chunk of memory is
> required (a large result-set from the database) no contigouis memory block
> of memory is availble in the current heap. The JVM claims more memory to
> expand the heap, grows and grows until it cosses the limmit. But I also
> tought that garbage collection takes care of that too.
>
> I hope some one has seen this behaviour and can point me in the right
> direction.
>
> TIA.
>
> Frank.
>
>
> --
> Met vriendelijke groet,
> Frank Brouwer
>
> _________________________________________________
>
> Trimergo BV
> Project Manufacturing Software
>
> Amersfoortseweg 15 C
> 7313 AB Apeldoorn, Nederland
> Telefoon: 055 - 577 7373
> Telefax: 055 - 577 7370
>
> www.trimergo.com
>
>

Relevant Pages

  • Re: Huge data
    ... >> connect everytime to the database to get a record or a group of records ... >> take more time than retreiving all the data and work with it offline, ... > underlying database connection each time - connection pooling takes ... > memory at a time, unless you're updating every row in the table. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: dataset Performence Issue
    ... Microsoft that a DataSet is okay to abuse as a DataBase. ... Managed Code can never be as fast and as optimized ... very good for 90% of the situations i.e. normal memory usage, ... Merge/GetChanges - and oh lets not forget keeping your disconnected cache ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Selecting from Datasets
    ... SQL provider manage Connection pooling which mean whatever sqlConnection ... instance you call it's just one virtual connection with the database managed ... > If I then have a datagrid and I only want it to display Field 1 and field ... > is no longer displayed on the page, so there shouldn't be a memory ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Oracle connections and memory usage
    ... > each connection to the database is sucking up 7MB of memory which ... > Is there anything that I can tune to improve memory usage or is there ... SG24-5511-00 Database Performance on AIX in DB2 UDB and Oracle Environments ... No. *I* am your father. ...
    (AIX-L)
  • Re: To Normalize or not ??
    ... The problem is that when you run a split database, ... save a word document (it is in memory, and thus does not get saved). ... ms-access is different then excel or word. ... database server. ...
    (microsoft.public.access.formscoding)