Advantages Over SQL SERVER Always on over Clustering
-
can anyone give the Advantages Over SQL SERVER Always on over Clustering
-
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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
what is advantages of Always On over SQL Server Clustering
-
Arjun SreeVastsva (5/14/2015)
what is advantages of Always On over SQL Server Clustering1) 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 -
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply