Solved

SQL 2012 and SQL 2014 always on

Posted on 2016-11-09
9
61 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 28

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
Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

 
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

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!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
encrypt SQL Server 2008 port 1433 3 41
How can I modify my merge data stored procedure? 3 33
rolling count by date, hour query 7 27
VM SQL server license. 1 52
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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

738 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