dbTalk Databases Forums  

Memory configuration for sql server 2000 active/passive cluster

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Memory configuration for sql server 2000 active/passive cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Memory configuration for sql server 2000 active/passive cluster in the microsoft.public.sqlserver.clustering forum.



Reply
Page 1 of 6 1 2 3 4 5 6 >
 
Thread Tools Display Modes
  #1  
Old   
Balaji
 
Posts: n/a

Default Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 02:03 AM





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

Reply With Quote
  #2  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM





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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #3  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #4  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #5  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #6  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #7  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #8  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #9  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
  #10  
Old   
Uri Dimant
 
Posts: n/a

Default Re: Memory configuration for sql server 2000 active/passive cluster - 01-10-2008 , 05:48 AM


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" <Balaji (AT) discussions (DOT) microsoft.com> wrote

Quote:
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



Reply With Quote
Reply
Page 1 of 6 1 2 3 4 5 6 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top