Tag: AAG

SQL 2014 Always-on AG Pt. 10: AAG Setup

After a brief pause in this SQL 2014 AlwaysOn Availability Group series, we are resuming with the server configuration. In this installment we will configure the Windows firewall to allow the two SQL servers to communicate to each other, configure a shared folder for the SQL replication, and finally configure...

SQL 2014 Always-on AG Pt. 7: TempDB

One of the most important aspects of SQL performance is TempDB. Applications can use TempDB as a scratch space, and in most cases you should not rely on just a single TempDB file. If the number of vCPUs is less than 8, then configure an equal number of TempDB files...

SQL 2014 Always-On Pt. 6: Cluster Config

 We've now come to the point where we need to install and configure the Windows cluster role. Even though SQL AAGs don't use shared disks like a traditional failover cluster, AAGs do rely on the Windows cluster service. We will also be implementing the Cluster Aware updating feature. This is...

Page 2 of 2 1 2
Scroll to Top