Some tips for SQL Server 2016 clustering Avoid running other software on the SQL Server 2016 cluster nodes. To increase SQL Server 2016 performance, SQL Server clusters should be dedicated to SQL Server only. Consider using Distributed Availability Groups (DAG) if you have two availability groups residing on different Windows Server Failover Clusters (WSFC). DAG enables you to associate two […]
Tag: node
SQL Server 2012 Clustering Optimization Tips
SQL Server 2012 Clustering Optimization Tips You can use cross-cluster migration of AlwaysOn Availability Groups for OS upgrade. SQL Server 2012 service pack 1 introduces support for cross-cluster migration of AlwaysOn Availability Groups for deployments to a new Windows Server Failover Clustering cluster. A cross-cluster migration moves one AlwaysOn availability group to the new destination Windows Server Failover Clustering cluster...
Troubleshooting problems with SQL Server 2008 R2 cluster
Troubleshooting problems with SQL Server 2008 R2 cluster If you have problems with SQL Server 2008 R2 cluster, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 cluster bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack....