I am assuming that because you are able to do this on the other node, you
are using AWE?
On the node you are having trouble with, either on the computer properties
pages or through System Info, how much physical RAM is being reported?
Are there any other programs running on the problem node that are also
consuming large amounts of RAM?
Finally, output the results of sp_configure here.
What do the performance counters report?
Memory:Commit Limit
Memory:Available Bytes
Process:Private Bytes(sqlservr)
Process:Virtual Bytes(sqlservr)
Process:Working Set Bytes(sqlservr)
Process:Private Bytes(_total)
Process:Virtual Bytes(_total)
Process:Working Set Bytes(_total)
SQL Server Buffer Manager:AWE*
SQL Server Buffer Manager:Target Pages
SQL Server Buffer Manager:Total Pages
SQL Server Memory Manager:Target Server Memory
SQL Server Memory Manager:Total Server Memory
Sincerely,
Anthony Thomas
--
[quoted text, click to view] "turky" <turky@discussions.microsoft.com> wrote in message
news:70AA8C84-1309-48AC-99CB-EC68A83C94A9@microsoft.com...
> Thank you for reply
>
> i checked the boot.ini and i found it as :
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced
> server" /fastdetect /PAE
>
> but i still can not increase the memory
>
>
>
> "Anthony Thomas" wrote:
>
> > When a server has more than 4 GB of memory installed, you must enable
PAE in
> > order for the OS to use, or even see, it.
> >
> > On Windows Server 2003, this happens automatically whenever more than 4
GB
> > is detected; however, for Windows 2000 Advanced Server, you have to
enable
> > it through the BOOT configuration: /PAE on the boot line.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > --
> >
> > "turky" <turky@discussions.microsoft.com> wrote in message
> > news:EADAAD36-204F-40A8-B3A2-0B98E4EAE40A@microsoft.com...
> > > I have SQL 2005 failover Clusterring on windows 2000 adv. server with
> > > physical memory 8 GB , i can increase the max memory to 6000 MB in the
> > first
> > > node but when i move cluster to second node i can not increase the max
> > memory
> > > to more than 2100 MB , i want to the second to be online with max
memory
> > 6000
> > > MB cause it has 1 GIGA Network connection,
> > > please help
> >
> >
> >
