dbTalk Databases Forums  

(Cluster) Memory settings

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


Discuss (Cluster) Memory settings in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AA
 
Posts: n/a

Default (Cluster) Memory settings - 04-12-2004 , 03:36 PM






Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000

Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.

So, That is possible?

1) Is possible to have differentes memory configuration in a cluster?
2) SQL 2000 and Windows 2003 supports 6GB of Physical Memory?


Thanks a lot!!


AA




Reply With Quote
  #2  
Old   
Sinisa Perovic
 
Posts: n/a

Default RE: (Cluster) Memory settings - 04-14-2004 , 06:31 AM






Do not do this. Just remember that some day resources from node one with 6GB of memory failover to node 2 with 2GB of memory. What will you do the

rgd
Sinisa Perovic

Reply With Quote
  #3  
Old   
Michael Hotek
 
Posts: n/a

Default Re: (Cluster) Memory settings - 04-17-2004 , 03:17 AM



What you will do then is exactly what everyone has to do who is running a
configuration with dissimilar processing capacity. You plan for the case
where both are running on the node with the least power. You estimate the
degradation in performance for the applications based on various load and
time scenarios. You then make a business decision as to whether that
degradation in performance during that specific downtime scenario is
acceptable or not. If it is acceptable, you configure it and off you go.
If it isn't acceptable, you come up with alternatives. Saying to not ever
do this is a very simplistic answer that simply is not correct.

--

Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com



Reply With Quote
Reply




Thread Tools
Display Modes

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.