May 14, 2015 at 6:02 am
can anyone give the Advantages Over SQL SERVER Always on over Clustering
May 14, 2015 at 6:03 am
To start, Always On is not a feature. It's a marketing term. The two features which fall under that marketing terms are Failover Clustering and Availability Groups. Which are you asking about?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 14, 2015 at 7:28 am
what is advantages of Always On over SQL Server Clustering
May 14, 2015 at 8:30 am
Arjun SreeVastsva (5/14/2015)
what is advantages of Always On over SQL Server Clustering
1) Don't need shared storage is the most prominent advantage for most I think.
2) Can set up readable-secondaries. HUGE GOTCHA HERE THOUGH!!
3) Can have multiple copies of database on different servers, both synchronous and asynchrounous.
DOWNSIDES
1) ENTERPRISE ONLY
2) See item 2 above
3) ONE thread to move/replay tlog activity. Can be a bottleneck on busy systems
4) COMPLEX with numerous caveats, provisos, limitations, gotchas. I have seen SOOO many clients and forum posters mess it up by just slapping it into production without knowing what they are doing!!!! And since it is part of HA/DR, if you screw it up you can literally cause your company to go out of business (yes, I have seen bad HA/DR cause that in the real world).
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
May 14, 2015 at 8:33 am
please read through my stairway article on this site, starting at this link
http://www.sqlservercentral.com/articles/FCI/107536/[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply