Dell PowerEdge External Media System 1434 Dell High Availability and Disaster - Page 3

Page 3 highlights

Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn Availability Groups Contents Executive summary ...4 Introduction ...4 Objectives...5 Why Dell server and storage hardware for AlwaysOn setup 5 Processors ...5 Memory ...5 Internal storage (HDD and SSD 5 Introduction to Microsoft SQL Server 2012 AlwaysOn Availability Groups (AVG 6 AlwaysOn Availability Groups Architecture 6 Most common HA and DR deployments for SQL databases 7 Dell reference configuration for AVG 8 AVG deployments on non-shared storage 8 Major advantages and limitations of implementing AVG on non-shared storage 9 AVG deployments on shared storage 10 Advantages and limitations of implementing AVG on shared storage 14 AVG deployments on hybrid (HDD and SSD) storage 14 Benefits ...14 Advantages and limitations of implementing AVG on hybrid (SSDs and HDDs) storage 15 Flexible failover policies and enhanced diagnostics for detecting failover conditions 15 Summary ...16 Figures Figure 1. Figure 2. Figure 3. Figure 4. Figure 5. Figure 6. Figure 7. Availability Groups on WSFC 7 Simple AVG deployment on PE R720XD local storage 9 Scenario 1 : SQL Server FCI with AVG on shared storage 11 Scenario 2 : SQL Server FCI with AVG on shared storage 12 Creating AVG with FCI 13 FCI with AVG deployment setting 13 AVG deployments on SSD and HDD 14 3

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn
Availability Groups
3
Contents
Executive summary
.......................................................................................................
4
Introduction
................................................................................................................
4
Objectives
................................................................................................................
5
Why Dell server and storage hardware for AlwaysOn setup?
....................................................
5
Processors
.............................................................................................................
5
Memory
................................................................................................................
5
Internal storage (HDD and SSD)
...................................................................................
5
Introduction to Microsoft SQL Server 2012 AlwaysOn Availability Groups (AVG)
...............................
6
AlwaysOn Availability Groups Architecture
........................................................................
6
Most common HA and DR deployments for SQL databases
......................................................
7
Dell reference configuration for AVG
...............................................................................
8
AVG deployments on non-shared storage
..........................................................................
8
Major advantages and limitations of implementing AVG on non-shared storage
.........................
9
AVG deployments on shared storage
..............................................................................
10
Advantages and limitations of implementing AVG on shared storage
....................................
14
AVG deployments on hybrid (HDD and SSD) storage
............................................................
14
Benefits
..............................................................................................................
14
Advantages and limitations of implementing AVG on hybrid (SSDs and
HDDs) storage
...............
15
Flexible failover policies and enhanced diagnostics for detecting failover conditions
..................
15
Summary
..................................................................................................................
16
Figures
Figure 1.
Availability Groups on WSFC
.............................................................................
7
Figure 2.
Simple AVG deployment on PE R720XD local storage
................................................
9
Figure 3.
Scenario 1 : SQL Server FCI with AVG on shared storage
.........................................
11
Figure 4.
Scenario 2 : SQL Server FCI with AVG on shared storage
.........................................
12
Figure 5.
Creating AVG with FCI
...................................................................................
13
Figure 6.
FCI with AVG deployment setting
.....................................................................
13
Figure 7.
AVG deployments on SSD and HDD
....................................................................
14