SQL Server Administration and Maintenance

SQH11 Using SQL Server AlwaysOn Availability Groups

11/16/2017

2:30pm - 3:45pm

Level: Introductory to Intermediate

Denny Cherry

Principal Consultant

Denny Cherry & Associates Consulting

In this session we will look at the features which are provided with Microsoft SQL Server 2012 & 2014 as part of the "AlwaysOn Availability Group" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.

Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database. We will also look a unique use case using SQL Server AlwaysOn Availability Group feature to scale out the reads to synchronous and/or asynchronous read only copies.

You will learn:

  • How to setup "AlwaysOn"
  • How to leverage "AlwaysOn" to increase production performance by offloading reporting and backups
  • When not to use AlwaysOn Availability Groups