|
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. 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%. |
