• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

SQL 2012 and SQL 2014 in memory database

hi,

what is the diff between SQL 2012 and SQL 2014 in memory database engine ?
0
marrowyung
Asked:
marrowyung
  • 5
  • 3
  • 2
  • +1
3 Solutions
 
Pawan KumarDatabase ExpertCommented:
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
 
marrowyungAuthor Commented:
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
 
Pawan KumarDatabase ExpertCommented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
what is the diff between SQL 2012 and SQL 2014 in memory database engine ?
MSSQL 2012 doesn't have In-Memory OLTP feature.
0
 
marrowyungAuthor Commented:
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
 
ste5anSenior DeveloperCommented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
marrowyungAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
marrowyungAuthor Commented:
ok , i will take that advice and search sth more and reply to you all.
0
 
marrowyungAuthor Commented:
tks all
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now