Re: SQL Memory - The SQL Server can not use more than 2GB

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/06/04 

Date: Fri, 5 Mar 2004 21:45:20 -0500

Howmuch memory do you actually have? Are you sure of the editions of the OS
and SQL Server? 

-- 
Andrew J. Kelly  SQL MVP
"Yuri G.Quaresma" <yquaresma@gmx.net> wrote in message
news:OfgTT1tAEHA.1076@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> This is my server cluster configuration:
> Windows 2000 Advanced Server SP3
> SQL Enterprise Edition SP3a
>
> I have this cluster configured as active-active and each node there is an
> instance of SQL Server 2000.
> My problem is that each instance just use 1.5Gb of memory in each node. I
> have configured the SQL Server memory to use dinamic allocation and
included
> the BOOT.INI parameter /3GB.
>
> I have identified the maximum SQL Server memory using Performance Monitor.
> When I have set the SQL to use fixed memory in more than 2GB, it starts
and
> make the SQL Server counters disapeared in Performance Monitor, when a set
> the memory to use dinamically allocation I can use the counters again.
>
> Am I missing something? Is it correct?
>
>
>
>
>

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)