Tips to work with SQL Server 2019 clustering Consider using SQL Server 2019 Big Data Clusters. SQL Server Big Data Clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes. With Big Data Clusters you can read, write, and process big data from Transact-SQL or Spark. Set the performance boost for the foreground...
Tag: active/passive
Some tips for SQL Server 2016 clustering
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 […]
SQL Server 2014 Clustering Optimization Tips
SQL Server 2014 Clustering Optimization Tips Create a cluster resource group before installing SQL Server 2014 clustering. Avoid installing SQL Server 2014 into the default cluster group. To create cluster resource group dedicated for SQL Server 2014, you can use the Cluster Administrator tool. You should also place all the shared array drives that will be used by SQL Server...