Post reply

sql server 2012 clustering

  • September 5, 2014 at 5:54 am

    #290490

    Hi,

    I am new to Sql server 2012 clustering and seeking few recommendations from experts for best practices as this will be a critical production application. I have below environment to have a cluster setup.

    1. Two Windows server 2012 Data center

    2. SQL server 2012 Enterprise Edition

    3. One SAN storage.

    Please let me know the following.

    1. Advantages and Disadvantages of AlwaysOn using Availability groups.

    2. Either 2 go for shared storage of individual storage if I am going for AlwaysOn methodology.

    3. Does AlwaysOn Availability required Cluster IP.

    If I see the Alwayson methodology has to have 2 different storages, the I am going for Failover with active-passive. If I am going for active-passive do I need to have clustered ip.

    Please let me know your recommendations with best practices.

  • September 8, 2014 at 2:30 am

    #1743801

    sanei05 (9/5/2014)

    Hi,

    I am new to Sql server 2012 clustering and seeking few recommendations from experts for best practices as this will be a critical production application. I have below environment to have a cluster setup.

    1. Two Windows server 2012 Data center

    2. SQL server 2012 Enterprise Edition

    3. One SAN storage.

    Please let me know the following.

    1. Advantages and Disadvantages of AlwaysOn using Availability groups.

    2. Either 2 go for shared storage of individual storage if I am going for AlwaysOn methodology.

    3. Does AlwaysOn Availability required Cluster IP.

    If I see the Alwayson methodology has to have 2 different storages, the I am going for Failover with active-passive. If I am going for active-passive do I need to have clustered ip.

    Please let me know your recommendations with best practices.

    From your description you seem a little confused.

    Do you intend to deploy any failover cluster instances of SQL server (which will require shared storage) or do you plan to just use standalone instances for your AlwaysOn group replicas?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply