How to design SQL Server 2005 scablable Architecture

Discussion in 'microsoft.public.sqlserver.clustering' started by Adeel Ahmed, Apr 23, 2009.

  1. Adeel Ahmed

    Adeel Ahmed Guest

    I have read lot of articles on SQL Server 2005 clustering and find out that
    the SQL Server 2005 doesn't support Active/Active clusters out of the box.
    But some techniques exist like Data Dependency Routing using Distributed
    partition views etc.

    Actually, i want to design architecture of a highly scalable web site that
    supports 100,000 hits simultaneously. For this i am planning to create a
    server farm (3 Web Servers) and will use NLB (Network Load Balancer)
    service of Windows 2003.

    But as you know, databases always bottle neck when you talk about high
    availability & scalability so i want to know what is the recommended
    architecture of Database to support this design?

    How can i distribute database on multiple server (like 3 DB Servers) and
    allow load balancing between them?
    What is the recommended web server routing technique? (NLB VS any other load
    balancer like Foundry ServerIron Load Balancer) and what is the advantages
    of using NLB?

    Adeel Ahmed, Apr 23, 2009
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.