Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sandba00
Starting Member
6 Posts |
 Posted - 2014-09-05 : 07:45:52
|
| 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 center2. SQL server 2012 Enterprise Edition3. 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. sandeep |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-09-05 : 11:37:10
|
| Each instance in an Availability Group will have its own drives. They can all point to the same SAN. With AG, you use double the storage (for 2 replicas), whereas with a 2-node Windows failover cluster you'd only have one copy (shared storage). The AG listener is similar to the virtual name used in a Windows failover cluster. Both need an IP address. We also use multi-subnet, so our AG listeners have 2 IPs.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
fish9044
Starting Member
1 Post |
Posted - 2014-09-06 : 11:38:51
|
| This is a great tutorial on how to use SQL.unspammed |
|
|
|
|
|
|
SQL server 2012 Clustering