Re: Best Practices for Cluster Groups

From: Bjornmob (anonymous_at_discussions.microsoft.com)
Date: 02/20/04 

Date: Thu, 19 Feb 2004 22:53:45 -0800

Hope you're still monitoring the thread :-)

The msdtc can reside in the cluster group but you need to
think twize before placing the msdtc log files on the
quorum disk. If you use msdtc a lot this could cause
serious cluster problems. MOM is a typical case which
recommends at least 512 MB for the msdtc log. The quorum
disk should be cared for!

"Other resources":
All resources for a virtual server should be in the same
cluster group. That is Network Name, IP, Disks, SQL Server
and SQL Server Agent. You havn't got much of an
alternative either as there are dependencies among them.
You cannot have cross-group dependencies.

SQL Server setup does all this for you. All resources will
be created in the cluster group where the data disk is
located.

HTH

>-----Original Message-----
>Hi Linchi
>Thanks for that. When I mean "other resources", I'm
>talking about the Windows cluster resources.
>Should I put MS-DTC, Quorum and other windows cluster
>resources together and the SQL resources all in their own
>cluster group? I understand that the cluster group's
>resources will all fail-over together but I'm not sure
>how/why to seperate the resources into these groups. Is
it
>base on dependencies?
>Thanks
>J
>
>
>>-----Original Message-----
>>See comments in line.
>>
>>>1) Place the Quorum and MS-DTC resources in a cluster
>>>group together.
>>
>>This is okay.
>>
>>>2) Place all other SQL and Windows resources in another
>>>cluster group together?
>>
>>Only the SQL Server related resources (i.e. those
created
>>by the SQL install plus any additional disk resources
you
>>may add for SQL Server to use) should be in the same
>>group. 'Other Windows resources', if any, should not be
>>placed in the SQL Server resource group. Especially
there
>>shouldn't be any unnecessary dependencies that may cause
>>problems for the SQL Server resources.
>>
>>Linchi
>>
>>.
>>
>.
>

Relevant Pages

  • Re: SP3a on cluster...help please
    ... If you have all nodes online, the SP install will work 'cluster-wide' on all ... remember to start the service pack from the node that currently owns the SQL ... I support the Professional Association for SQL Server ... > "While performing the cluster portion of SQL Server 2000> SP3 or SP3a, the setup will reset all cluster resources to> the default properties for all resources in the group,> whether they are related to SQL Server or not." ...
    (microsoft.public.sqlserver.clustering)
  • Re: SBSMonitoring and Sharepoint DB Movement
    ... Installing a ful blown version of SQL server will not neecssarilly save more ... resources than taking the approach mentioned above. ... Sql Server/MSDE instances on SBS: ... sbsmonitoring/sharepoint databases that are installed by default in SBS ...
    (microsoft.public.windows.server.sbs)
  • Re: How to remove (uninstall ) cluster sql server manually
    ... just keep the group and the disk resource. ... Do i need to delete sql group also to clean the sql server? ... check out www.clusterhelp.com for suitable training in clusters. ... I did not delete any resources in cluadmin. ...
    (microsoft.public.sqlserver.clustering)
  • SQL Server 2000 Cluster Manual Failover
    ... I have a two-node SQL Server 2000 cluster running on Windows 2003 SP1. ... cluster resources set up in 4 groups. ... I've noticed that if I try to manually fail over one of the SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to remove (uninstall ) cluster sql server manually
    ... SQL Server MVP ... I have deleted cluster resources as you said. ...
    (microsoft.public.sqlserver.clustering)
Loading