Memory configuration for sql server 2000 active/passive cl..

Hi Uri and Kevin,

Thanks to both of for the response. Each node has 4GB of RAM and it is a
active/passive cluster.

Regards
Balaji

"Kevin3NF" wrote:

> Leave some memory for the O/S...don't make Windows steal from SQL....
>
> --
>
> Kevin3NF
> SQL Server dude
>
> You want fries with that?
> http://kevin3nf.blogspot.com/
>
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>
>
> "Balaji" wrote in message
>
> > Dear All,
> >
> > We are installating an acive/passive sql server 2000 cluster. One of my
> > friend recommended to configure the max server memory as total server
> > memory
> > - 256. When I asked him why, he said it will prevent SQL Serer 2000 from
> > using all the available memory on the server and it will help the
> > operating
> > system to failover the sql server to secondary node smoothly when there is
> > a
> > trouble.
> >
> > Can I follow this recommendation.
> >
> > Regards
> > Balaji
>
>
>
 >> Stay informed about: Memory configuration for sql server 2000 active/passive cl.. 

I would turn on the /3GB switch in BOOT.INI and set the max server memory
for SQL Server to 3GB. I like to leave at least 1GB for the OS.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Balaji" wrote in message

Hi Uri and Kevin,

Thanks to both of for the response. Each node has 4GB of RAM and it is a
active/passive cluster.

Regards
Balaji

"Kevin3NF" wrote:

> Leave some memory for the O/S...don't make Windows steal from SQL....
>
> --
>
> Kevin3NF
> SQL Server dude
>
> You want fries with that?
> http://kevin3nf.blogspot.com/
>
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
>
>
> "Balaji" wrote in message
>
> > Dear All,
> >
> > We are installating an acive/passive sql server 2000 cluster. One of my
> > friend recommended to configure the max server memory as total server
> > memory
> > - 256. When I asked him why, he said it will prevent SQL Serer 2000 from
> > using all the available memory on the server and it will help the
> > operating
> > system to failover the sql server to secondary node smoothly when there
> > is
> > a
> > trouble.
> >
> > Can I follow this recommendation.
> >
> > Regards
> > Balaji
>
>
>
 >> Stay informed about: Memory configuration for sql server 2000 active/passive cl.. 

Hi
What is your total memory? For example we have one cluster server with 8GB,
so we configured 6GB for SQL Server and 2GB for OS. You have to test it by
yourself.

"Balaji" wrote in message

> Dear All,
>
> We are installating an acive/passive sql server 2000 cluster. One of my
> friend recommended to configure the max server memory as total server
> memory
> - 256. When I asked him why, he said it will prevent SQL Serer 2000 from
> using all the available memory on the server and it will help the
> operating
> system to failover the sql server to secondary node smoothly when there is
> a
> trouble.
>
> Can I follow this recommendation.
>
> Regards
> Balaji
 >> Stay informed about: Memory configuration for sql server 2000 active/passive cl.. 

Hi
Try add /3GB in boot.ini file. Install hotfix
from(http://support.microsoft.com/kb/899761) on 'active' node



"Balaji" wrote in message

> Hi Uri and Kevin,
>
> Thanks to both of for the response. Each node has 4GB of RAM and it is a
> active/passive cluster.
>
> Regards
> Balaji
>
> "Kevin3NF" wrote:
>
>> Leave some memory for the O/S...don't make Windows steal from SQL....
>>
>> --
>>
>> Kevin3NF
>> SQL Server dude
>>
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>>
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>>
>>
>> "Balaji" wrote in message
>>
>> > Dear All,
>> >
>> > We are installating an acive/passive sql server 2000 cluster. One of my
>> > friend recommended to configure the max server memory as total server
>> > memory
>> > - 256. When I asked him why, he said it will prevent SQL Serer 2000
>> > from
>> > using all the available memory on the server and it will help the
>> > operating
>> > system to failover the sql server to secondary node smoothly when there
>> > is
>> > a
>> > trouble.
>> >
>> > Can I follow this recommendation.
>> >
>> > Regards
>> > Balaji
>>
>>
>>
 >> Stay informed about: Memory configuration for sql server 2000 active/passive cl..