Solved

SQL 2012 and SQL 2014 always on

Posted on 2016-11-09
9
29 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
  • 5
  • 3
9 Comments
 
LVL 24

Expert Comment

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

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
 
LVL 1

Author Comment

by:marrowyung
ID: 41881795
SQL2012 and SQL2014 replica can't be read/write anyway ?
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 46

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 46

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

919 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now