Dell PowerEdge SDS 100 Dell High Availability and Disaster Recovery Solutions
Dell PowerEdge SDS 100 Manual
 |
View all Dell PowerEdge SDS 100 manuals
Add to My Manuals
Save this manual to your list of manuals |
Dell PowerEdge SDS 100 manual content summary:
- Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 1
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn Availability Groups Dell servers and storage options available for AlwaysOn Availability Groups deployment. Gopu Narasimha Reddy Dell Database Solutions Engineering - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 2
omissions in typography or photography. Dell, the Dell logo, PowerVault, and PowerEdge are trademarks of Dell Inc. Intel is a registered trademark of Intel Corporation in the U.S. and other countries. Microsoft, Windows, Windows Server, and SQL Server are either trademarks or registered trademarks - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 3
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 - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 4
on Dell™ 12th Generation PowerEdge™ Servers. The guidelines and recommendations for implementing AVG will be illustrated by a review of some of the possible user scenarios. We will also discuss how PowerEdge Servers can be combined in a variety of server and storage configurations that make Dell the - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 5
PowerEdge R720xd can handle the storage-intensive databases needs of the entrylevel customer without demanding external storage. It supports 24 front-accessible 2.5-inch SAS drives, and provides a single server and storage platform for deploying AlwaysOn AVG databases. The Dell PowerEdge R720/R820 - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 6
possible the installation of applications that require high-bandwidth on the same system. By combining the processing power of the multi-core Intel Sandy Bridge processors, high performing internal storage, large levels of RAM and enough PCIe Cards, the PowerEdge 12th Generation rack servers provide - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 7
of failover. Up to four AsynchronousCommit Mode replicas (with manual failover) are supported. Windows Server Failover Cluster (WSFC): All availability replicas (primary and secondary) participating in the AVG deployment must be installed on the different nodes of the same WFSC cluster. However - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 8
its high performing internal storage and huge processing power, Dell's 12th Generation PowerEdge R720xd server is an excellent single platform choice for hosting AlwaysOn databases that have large processing power, memory, and high-performing storage requirements. R720xd supports a maximum of 38TB - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 9
configuration, we used fully populated PowerEdge R720xd servers in the primary site and DR site. Two RAID-10 (10 disks for each) virtual disks are carved out from 20 disks to store the database files, and one RAID 1 virtual disk from the two drives for storing T-Log files. The last two hard drives - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 10
which are part of FCIs will require shared storage as per standard SQL Server failover instance installation. An FCI may be used together with Server FCIs do not support automatic failover by availability groups, any availability replica that is hosted by an FCI can only be configured for manual - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 11
aspects of the configuration described in Figure 3 are: HA is achieved at both the primary and DR sites. Should the primary site fail completely (both nodes in primary site), a manual failover has to be triggered at the DR site (this is because Automatic failover is not supported when FCIs are - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 12
: In this configuration, automatic failover is achieved with the FCI instance which might be running on Node1 or Node2 at any point in time. Since the FCI instance does not support automatic failover/failback when we combined it with Availability Groups, we may have to do a manual failover to Node3 - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 13
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn Availability Groups We validated the configuration outlined in Figure 4 using four PowerEdge R720 servers. Figure 5 shows the replica configuration window of the New Availability Group wizard. Figure 5. - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 14
databases within the primary site. Dell 12th generation servers (such as the R720 and R820) come with support for front-loading PCIe SSD drives. Benefits Dell™ PowerEdge R720 and R820 servers support up to four 2.5-inch 350G front-access PCIe SSDs drives. Figure 7 shows a possible deployment of - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 15
implementation, two PowerEdge R720 servers in the primary site were deployed with PCIe SSD drives. The databases that are part of the AVG are stored on the SSD drives. Remaining databases may be stored on the traditional hard drives. These two servers should be configured in synchronous commit - Dell PowerEdge SDS 100 | Dell High Availability and Disaster Recovery Solutions - Page 16
control to achieve HA and DR of the SQL databases. Dell 12th Generation PowerEdge servers provide the right platform for implementing the AVGs by supporting the tremendous processing power with E5 series processors, large memory (with 1600Mhz DIMMS) and high performing local storage. Dell PowerEdge
-
1 -
2 -
3 -
4 -
5 -
6 -
7 -
8
-
9
-
10
-
11
-
12
-
13
-
14
-
15
-
16
 |
 |
Gopu Narasimha Reddy
Dell Database Solutions Engineering
Dell High Availability and Disaster
Recovery Solutions Using Microsoft
SQL Server 2012 AlwaysOn Availability
Groups
Dell servers and storage options available for AlwaysOn Availability
Groups deployment.