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

From: Yuri G.Quaresma (yquaresma_at_gmx.net)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 15:15:13 -0300

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: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)