SQL 2012 and SQL 2014 always on

hi,

any link shows the diff between SQL 2012 and SQL 2014 always on technology, I knew that the replica of SQL 2012 alwayson can be read only already, how about SQL 2014? what is the diff between these ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
means in case of read operation, the read request will route to diff replica at any one time, read request spread across diff replica evenly
Ah, that depends on your connection type and how you configured the AG Listener. Doesn't do that by default, btw.

so SQL 2014 only do replica better than SQL 2012.
Not better but much (more number of replicas and possibility to use Azure as replica).
0
 
Pawan KumarDatabase ExpertCommented:
You want to look out for the differences between Always on in 2012 & 2014.?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
AlwaysOn was introduced on MSSQL 2012 and enhanced on MSSQL 2014.
So, basically you can do more things with AlwaysOn in MSSQL 2014 than in MSSQL 2012.
Beside minor improvements the more important ones are that in MSSQL 2014 the maximum number of replicas is 8 (was 4 in MSSQL 2012) and now you can add an Azure Instance for the AG so you can use it for example for DR.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
marrowyungSenior Technical architecture (Data)Author Commented:
" MSSQL 2014 the maximum number of replicas is 8 (was 4 in MSSQL 2012) and now you can add an Azure Instance for the AG so you can use it for example for DR."

yes, as the read only AG replica can be round robin, right?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
SQL2012 and SQL2014 replica can't be read/write anyway ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
yes, as the read only AG replica can be round robin, right?
What you mean with that?

SQL2012 and SQL2014 replica can't be read/write anyway ?
Replicas can't never be write replicas. They are always Read-Only replicas.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"What you mean with that?"

means in case of read operation, the read request will route to diff replica at any one time, read request spread across diff replica evenly

"Replicas can't never be write replicas. They are always Read-Only replicas."

so SQL 2014 only do replica better than SQL 2012.
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
"Ah, that depends on your connection type and how you configured the AG Listener. Doesn't do that by default, btw."

so only working for SQL2014 you mean ?

"Not better but much (more number of replicas and possibility to use Azure as replica)."

ok, read only anyway. much better for report purpose
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
tks victor.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.