Dell PowerEdge External Media System 1434 Using Manual

Also see for PowerEdge R720xd: Technical guide Technical guide Technical guide Getting started guide Owner's manual

Contents

Dell PowerEdge External Media System 1434 Using Manual Manual pdf 15 page image

Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOnAvailability Groups15In the above sample implementation, two PowerEdge R720 servers in the primary site were deployedwith PCIe SSD drives. The databases that are part of the AVG are stored on the SSD drives. Remainingdatabases may be stored on the traditional hard drives. These two servers should be configured insynchronous commit mode with automatic failover. In order to avoid network bottleneck between thehosts, make sure that the enough network bandwidth is deployed between the hosts. This will help toachieve high performing AVG databases, with fast failover/failback capabilities.As per the sample implementation shown in Figure 7, the DR site may have less costly hard drives(and/or storage) to host the secondary replica. The DR replicas should be configured in Asynchronouscommit mode. This implementation will help the customer reduce the overall cost of the entire HADRconfiguration.Advantages and limitations of implementing AVG on hybrid (SSDs and HDDs)storageAdvantages: Simple and cost effective solution for SMB customers who cannot invest in SAN Improved DB performance with PCIe SSDs Quicker failover and failback times compared to other solutionsLimitations: Limited storage scalability No enhanced SAN capabilitiesFlexible failover policies and enhanced diagnostics for detectingfailover conditionsSQL Server 2012 introduces more flexible failover polices and a rich set of diagnostics that enable WSFCto detect failures and take required actions as soon as possible. The SQL Server setup periodicallyreports a set of component diagnostics to the WSFC resource group. The WSFC resource groupmaintains the failover policy which defines the failure conditions that trigger restarts and failovers.SQL Server setup uses sp_server_diagnostics to collect the health status of the SQL Server components.The diagnostic information that is collected by sp_server_diagnostics includes System, Resource, Queryprocess, io_subsystem and Events. The first three components’ information is used for failoverdetection, while the last two components’ information is used for diagnostic purpose only.Failure conditions are set on an increasing scale. For levels 1-5, each level includes all the conditionsfrom the previous levels in addition to its own conditions. This means that with each level, there is anincreased probability of a failover or restart. 3 is the default setting for AVG and FCI. We use eitherCluster Management tools or T-SQL scripts to set the failover condition for FCI and AVG. For moreinformation about the SQL server flexible failover polices and diagnostics, referhttp://msdn.microsoft.com/en-us/library/ff878664.aspxDell conducted a variety of tests to determine how effectively WSFC and SQL Server work together toidentify the failover condition and take appropriate action. We observed that an AVG took a maximum

/ 16

Related manuals for Dell PowerEdge R720xd