Memory leak using JDBC driver for Microsoft SQL Server 2000 SP4

From: gp (parcha_at_gmail.com)
Date: 02/24/05

  • Next message: Alin Sinpalean: "Re: SQLServer 2000 Driver for JDBC behaviour on SQL Server restart" 
    Date: 24 Feb 2005 11:16:47 -0800

    Folks,
       I have installed SQL Server 2000-SP4 on a box different that that of
    my code.
       I am getting memory leaks(Out of memory errors in my code logs)
    writing to mainly two tables which have image, ntext using JDBC driver
    for SQL Server 2000 and only after running it for around 10 hours or
    so.
       If I disable writing to DB in the code, there is absolutely no
    problem.

    Any pointers would be grately appreciated.

    Note: My SQL Server doesn't hang up when I get this out of memory
    problem.

  • Next message: Alin Sinpalean: "Re: SQLServer 2000 Driver for JDBC behaviour on SQL Server restart"

    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)