SQL Server TechCenter >
SQL Server Forums
>
SQL Server Disaster Recovery and Availability
>
User Services in Cluster SQL Group
User Services in Cluster SQL Group
- I have a question in SQL Server cluster. There is a configuration that I see where the DBA has placed the user defined or user created application services in the same group as SQL Server group. I say that is not a best practice as the group may go down when those services get affected and I have asked them to create another group and place those services there. Is there anyother reason that i can say to justify that the resources should be placed in different group than the SQL group. your suggestions are all appreciated.ThanksSugeshkumar
SugeshKumar
SQL Server MVP
http://sugeshkr.blogspot.com
All Replies
- The rule of thumb is, the resources placed in a group are related. In my opinion, the group is used for the purpose of categorizing the related resources. For example, you can click the context menu item "show dependency" to show the relationship between all resources in one group. And the group is a failover unit, if one resource down, the customizable group policy will decide to failover the whole group to the other node or restart the whole group in the current node.
It doesn't make sense to place an irrelevant resource to a group. Because when the other resources fails, the irrelevant resource will be forced to failover(or restart on the same machine) alltogether.- Unproposed As Answer bySugesh KumarMVPFriday, October 30, 2009 4:35 PM
- Proposed As Answer byNimit Parikh Thursday, October 29, 2009 3:40 AM
- This might be helpful:
http://support.microsoft.com/kb/835185
This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL
