Solved

SQL 2012 and SQL 2014 in memory database

Posted on 2016-11-09
11
65 Views
Last Modified: 2016-11-10
hi,

what is the diff between SQL 2012 and SQL 2014 in memory database engine ?
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
  • 2
  • +1
11 Comments
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41881673
In 2014 - SQL Server has introduced In-Memory OLTP Engine.

In-Memory OLTP can significantly improve OLTP database application performance. It improves throughput & improve performance of data scenarios such as temp tables and ETL.

In-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine, optimized for transaction processing.

If you want to read more for quick start - https://msdn.microsoft.com/en-in/library/mt694156.aspx

If you want to read more what new in the SQL Server - https://msdn.microsoft.com/en-us/library/bb500435(v=sql.120).aspx

Hope it helps!!
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41881677
I mean the in-memory database engine diff between SQL 2012 and SQL 2014.

e.g. table in replication can't go to memory as it is the limitation .
0
 
LVL 28

Assisted Solution

by:Pawan Kumar
Pawan Kumar earned 125 total points
ID: 41881685
Memory-optimized tables are frequently accessed as part of OLTP. They are stored in memory and the Hard Drive. It improves the speed of transactions run against the tables because the SQL Server system only needs to interact with the data in memory.

These tables are fully durable, ensuring that data from completed transactions will be preserved even if a database crashes. They're accessed using T-SQL commands just like conventional tables.

For replication please go through - https://msdn.microsoft.com/en-us/library/dn600379.aspx

Hope it helps!
0
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41881770
what is the diff between SQL 2012 and SQL 2014 in memory database engine ?
MSSQL 2012 doesn't have In-Memory OLTP feature.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41881791
Victor,

but it has in memory table but seems allow only one non clustered index ?

it don't hav OLAP I knew. but OLTP should have?
0
 
LVL 34

Assisted Solution

by:ste5an
ste5an earned 125 total points
ID: 41881803
No in-mem prior to SQL Server 2014:

New in SQL Server 2014, In-Memory OLTP can significantly improve OLTP database application performance. In-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine, optimized for OLTP.
(In-Memory OLTP (In-Memory Optimization))

Do you mean column store indices?
0
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 41881814
but it has in memory table but seems allow only one non clustered index ?
In-Memory doesn't have indexes.

it don't hav OLAP I knew. but OLTP should have?
As far as I know there's no In-Memory feature for OLAP. Only OLTP.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41881848
Victor,

"As far as I know there's no In-Memory feature for OLAP. Only OLTP."

ok, from my remember, SQL 2012 has in memory table for tranaction process but not for Analysis service.

SQL 2014 has OLAP.

"In-Memory doesn't have indexes."

so in memory table don't allow index or SQL 2014 will have ?

ste5an,

I know what you mean, so what news is SQL 2012 then? always on with 4 x replica only ?
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 41881869
so in memory table don't allow index or SQL 2014 will have ?
Sorry, I wanted to say "has no clustered indexes".

ok, from my remember, SQL 2012 has in memory table for tranaction process but not for Analysis service.
Really? Can you provide an example?

SQL 2014 has OLAP.
SQL Server has OLAP since MSSQL 2000. What I mean is that In-Memory feature doesn't exists for OLAP as far as I know.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 41882331
ok , i will take that advice and search sth more and reply to you all.
0
 
LVL 1

Author Closing Comment

by:marrowyung
ID: 41883307
tks all
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

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