January 8, 2012 at 11:55 pm
Hi ,
what are the new features added in SQL Clustering 2008 ?
please let me know if anyone aware of these features !
Regards
Subha..
January 9, 2012 at 2:45 am
http://www.google.com/search?q=new+features+in+SQL+2008+clustering
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 9, 2012 at 3:06 am
January 10, 2012 at 4:00 am
http://www.sqlserver-training.com/sql-server-2008-clustering-enhancements
Unfortunately most of the information in this link is wrong applies to Windows 2008 but not to SQL 2008. The multi-subnet clustering and support for OR dependencies never made it into SQL 2008 or R2. But the good news is they are in SQL 2012.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
January 10, 2012 at 4:12 am
For me, the main changes in SQL 2008 clustering compared to SQL 2005 are:
1) Explicit install options for creating the first node and adding additional nodes. This stops potentially unwanted SQL components being installed on all the cluster nodes that are active when you do your first node install.
2) The Cluster Groups are created by the SQL install if they do not exist. In SQL 2005 you had to create the groups before running the SQL install.
If you look at changes in clustering for Windows Server 2008 R2 compared to Windows Server 2003, then there are a lot more changes, many of which have a big impact on how you set up and operate your cluster.
A) The Cluster Manager tool is a lot easier to use and more reliable compared to the W2003 tool. But it does have some gotchas - mostly it will delete dependencies if you delete or move a cluster resource, but it will neither delete or show the dependencies that still exist if you move a disk resource to the Available Storage group.
B) You can have multiple MSDTC clusters with W2008, and you should exploit these to minimise cross-node traffic between SQL Server and MSDTC. However, getting this working is not always easy.
There are other changes, and different people could have other items they consider more important, but this is my list.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 4, 2012 at 7:58 pm
Hi ,
Thanks for your information .
Guys,
if you have any other information, please share with us. its really helpful those who are implementing sql 2008 clustering.
reagrds
Subha.
March 4, 2012 at 9:57 pm
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply