Solved

SQL 2012 and SQL 2014 always on

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

Expert Comment

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

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

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

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 47

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

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.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

822 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