Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Has anyone implemented SQL Server 2012 Always On for disaster recovery Expand / Collapse
Author
Message
Posted Friday, April 12, 2013 6:31 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 6:44 AM
Points: 81, Visits: 369
Am helping a client upgrade his servers (currently SS 2005 with Windows 2003 cluster). Talked to Dell sales rep this afternoon and he had not heard of anyone implementing Always On for DR. He said all his sales for SS2012 have been for active/passive cluster.

I've attended several SQL Saturday sessions and webinars on Always On, but now are worried that nobody has really implemented it in production. I don't want the client to be on the technology tip by himself, but would like to take advantage of Always On if it really works.

I would appreciate it if anybody could tell me if they have implemented Always On and what pros and cons they have found.

Thanks in advance,
Mike Byrd


Mike Byrd
Post #1441983
Posted Saturday, April 13, 2013 8:25 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:53 AM
Points: 4,350, Visits: 6,162
Mike Byrd (4/12/2013)
Am helping a client upgrade his servers (currently SS 2005 with Windows 2003 cluster). Talked to Dell sales rep this afternoon and he had not heard of anyone implementing Always On for DR. He said all his sales for SS2012 have been for active/passive cluster.

I've attended several SQL Saturday sessions and webinars on Always On, but now are worried that nobody has really implemented it in production. I don't want the client to be on the technology tip by himself, but would like to take advantage of Always On if it really works.

I would appreciate it if anybody could tell me if they have implemented Always On and what pros and cons they have found.

Thanks in advance,
Mike Byrd


Your sales person is either misinformed, speaking only based on knowledge that if people are making SQL Server Cluster they state so to ensure they get "certified" hardware or is straight-up lying to you to get you to buy more expensive "cluster certified" hardware. I have 4 clients that have or are in the process of setting up some form of 2012 "enhanced mirroring" (e.g. Always On) for HA/DR/read-only scale-out (or any combination of those 3). There are some amazingly compelling reasons and benefits, and given that it's foundational underpinnings is database mirroring which has been around since SQL 2005 SP1, it is pretty solid given that technically Always On is a v1+SP1 feature! The one con that I know of is a limitation of single-threading the stuff across and hardening it on secondary - which I have heard means a real-world 50MB/second throughput give or take. I note that that is a LOT of data/transactions and that 99.x% of the installed base will never get even close to that. Well, there is also the cost of SQL 2012 licensing as well as the requirement for a Windows Failover Cluster of all machines involved (including any on a different subnet).

If you would like more information feel free to Private Message me.


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1442034
Posted Sunday, April 14, 2013 5:02 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:44 PM
Points: 400, Visits: 913
We just rolled out AlwaysOn in our reporting environment last week to replicate 2 databases from our data warehouse to allow our data analysts query the report databases without effecting the ETL processes during the day on the primary.

The only issue we found when rolling out one of the databases was that we had to turn off transaction log backups on the primary while the replica ws being made on the secondary. Its very early days but so far all is good - the setup was very straighforward and we are not having any issues with latency - we set it up as Asynchronous-commit mode as our primary is in Melbourne and Secondary in Darwin.

As I said its early days but so far so good!
Post #1442147
Posted Tuesday, May 7, 2013 12:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 11:38 AM
Points: 2, Visits: 9
Did you need to upgrade all of your SQL instances to 2012 in order to enable AlwaysOn?
Post #1450300
Posted Wednesday, May 8, 2013 8:43 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, August 16, 2014 5:48 AM
Points: 1,862, Visits: 3,602
We have implemented AlwaysOn Availability Groups (AG) on a 3-node cluster, consisting of 2 subnets: primary and DR.

2 nodes on the primary site host a failover-cluster instance (FCI) in an active-passive configuration.

The 3rd node on the DR hosts a standalone SQL instance, serving as a secondary AG replica in async-commit mode.

No issues so far with this configuration, although we have observed transaction-log latencies of up to 20 minutes between the primary and secondary replicas.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1450618
Posted Wednesday, May 8, 2013 10:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 11:38 AM
Points: 2, Visits: 9
@SSCommitted Did all of your database servers have to be upgraded to 2012 in order for your configuration to work?
Post #1450683
Posted Wednesday, May 8, 2013 10:47 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Saturday, August 16, 2014 5:48 AM
Points: 1,862, Visits: 3,602
fb.cs99 (5/8/2013)
@SSCommitted Did all of your database servers have to be upgraded to 2012 in order for your configuration to work?


Yes.
Also all database servers need to be in a Windows Server 2008 R2 SP1 (or later) Failover Cluster.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1450693
Posted Wednesday, July 17, 2013 10:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 1, 2014 12:30 PM
Points: 8, Visits: 129
I have implemented Always ON, here is the configuration

I have 3 node cluster , 1 with stand alone sql server and 2 nodes are HA active/passive sql server cluster. all three nodes are in same subnet

now i want to add another node for DR which is at some other location with different subnet. (Stand alone sql only)

i have the following question

will adding new node to the existing WINDOWS cluster bring down services in the cluster?




Post #1474712
Posted Thursday, July 18, 2013 10:31 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
I have recently did setup 2012 always on with 2 active/passive node with different NW subnet adding another instance in the AAG to be the mirroing. This is working fine.

"More Green More Oxygen !! Plant a tree today"
Post #1475268
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse