SQL Server Performance

Multi-Site High Availability Solution

Discussion in 'SQL Server Clustering' started by Danpitta, Jul 14, 2006.

  1. Danpitta New Member

    I want to:
    1: insure availability in the event of disaster, So I know I need to have multiple sites.

    2: minimze downtime
    minimize the maintenance windows for code deployment

    I think I want to
    1: share data between sites
    (perhaps some type of partitioning schema and replication)
    2: all sites to be active, active - active
    I don't really want to have a duplicate site sitting idle

    Where do I find an expert in this area? Are the any white paper best practices?

    Daniel J Pitta
  2. merrillaldrich New Member

    http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

    By Ron Talmage. Ron's a great guy.

    Don't know the performance implication of doing mirroring at two separate sites, though.

Share This Page