Tag: AlwaysOn Availability Groups

Pro Members SQL Server Standard Members

Tips to work with SQL Server 2017 clustering

by

Tips to work with SQL Server 2017 clustering You should proper configure the SQL Server 2017 service accounts. Ensure that each SQL Server 2017 service account is a domain account and a member of the Local Administrators group of each cluster node and a member of the Domain Users group. Set the SQL Server 2017 service accounts passwords to be...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Some tips for SQL Server 2016 clustering

by

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 […]

Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Merge Replication Optimization Tips (Part 2)

by

SQL Server 2014 Merge Replication Optimization Tips (Part 2) Do not forgive to script your replication configuration. Because scripting the replication configuration is a key part of any disaster recovery plan for a replication topology, you should script your replication configuration from the replication wizards or from the Replication folder in Microsoft SQL Server Management Studio. If you do not...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Merge Replication Optimization Tips (Part 1)

by

SQL Server 2014 Merge Replication Optimization Tips (Part 1) Create an index on each of the columns that is used in the filter’s WHERE clause. If you do not use indexes on columns used in filters the SQL Server must perform a table scan, which can results in performance degradation. Set the "Maximize Throughput for Network Applications" option. This can...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →