Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2? -
Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2? -
[cross posted dba.stackexchange]
brent ozar published webcast (slides, video free registration) entitled "real-life sql server 2012: alwayson lessons learned", in repeatedly states, varying degrees of force, that
using windows 2008r2 sql server 2012 availability groups bad idea
among issues raises are:
quorum recalculation (a feature of windows failover clustering introduced in windows 2012) numerous bugs requiring windows hotfixes (list in alwayson docs, "stackoverflow patch"), though i'm much less interested in problems fixed bringing deployment date.he doesn't talk other specifics of why using ags win2008r2 bad idea, other stating alwayson "pushes windows clustering harder other app, , uncovering breaking points". worth noting though supported configuration (alwayson scheme requirements).
what problems have been seen in new deployments using sql server 2012 alwayson availability groups windows server 2008 r2, , these eliminated using windows 2012? there problems seen in windows 2008r2 fixed in windows 2012 not have hotfixes available in 2008r2?
i have worked setting in both windows 2008 , 2012. didnt face much difference between them
sql-server windows-server-2008 sql-server-2012 windows-server-2008-r2 windows-clustering
Comments
Post a Comment