Disaster Recovery White Papers
High availability for SQL Server 2005 using array-based replication and host-based mirroring technologies
Overview
This white paper demonstrates that, in a highly-available disaster recovery environment using either HP StorageWorks Continuous Access EVA or Microsoft SQL Server 2005 database mirroring, checkpoint duration is critical to managing the solution behavior and implementation of the best practices results in significant performance improvements up to 52%.
This solution provides the information needed to select the replication, mirroring, and/or high availability method(s) suitable for your environment; and the best practices for optimal configuration of the SQL database, HP ProLiant blade servers, HP StorageWorks Enterprise Virtual Array (EVA)storage, and software. Both array-based replication with HP StorageWorks Continuous Access EVA and host-based copying with SQL Server database mirroring are discussed, along with strategies for synchronous and asynchronous replication of SQL databases between primary and remote HP EVA disk arrays.
Co-Sponsored by:
| Publisher | Hewlett-Packard (HP) | File Format | |
|---|---|---|---|
| Date Published | January 2008 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 9 out of 17 users found this white paper useful
White Paper RSSBusiness Continuity: How quickly do you plan to bounce back?
DownloadWatch this IBM ForwardView webshow to find out how Business Continuity Planning can help minimize the impact that downtime can have on your business, your customers, and your bottom line....
Fact Sheet : IBMXIV Storage System
The IBM XIV® Storage System is a ground-breaking, high-end disk system, designed to support business requirements for a highly available information infrastructure. Built from a grid of standard Intel®/Linux® components, it is...
IBM XIV® Storage System: Ease of Management Reinvented
Managing a storage system has become a costly and complicated task. The direct labour cost associated with its management is increasing. In addition, organizations incur hidden indirect costs due to...
IBM XIV® Storage System: Ideal Storage for the New Media Era
The last decade has seen a revolution in the way in which digital information is generated and organized. The IBM XIV® Storage System provides a revolutionary solution for these requirements,...
IBM XIV® Storage System: Thin Provisioning Reinvented
Managing IT storage infrastructure is an endless balancing act of providing enterprise-class functionality and services while controlling costs. "Thin provisioning" is the practice of allocating storage to applications on a...
