Solved

SQL 2012 and SQL 2014 always on

Posted on 2016-11-09
9
65 Views
Last Modified: 2016-11-10
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 ?
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 29

Expert Comment

by:Pawan Kumar
ID: 41881702
You want to look out for the differences between Always on in 2012 & 2014.?
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41881775
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
 
LVL 1

Author Comment

by:marrowyung
ID: 41881794
" 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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 1

Author Comment

by:marrowyung
ID: 41881795
SQL2012 and SQL2014 replica can't be read/write anyway ?
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41881811
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
 
LVL 1

Author Comment

by:marrowyung
ID: 41882336
"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
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41882406
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
 
LVL 1

Author Comment

by:marrowyung
ID: 41883189
"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
 
LVL 1

Author Closing Comment

by:marrowyung
ID: 41883190
tks victor.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question