In-Memory OLTP in SQL Server 2017
Please watch: "Columnstore Index Vs RowStore Index"
• Columnstore Index Vs RowStore Index -~-
SQL Server In-Memory OLTP, also known as Hekaton was introduced in SQL Server 2014. It provides us the ability to move tables/Sps into memory and it also compiles SPs in native code.
It offers a 5-20X time faster response as compared to the traditional disk-based tables and helps boost the transactional workloads in both SQL Server and Azure SQL Databases. Get the SQL Server 2017 or higher editions (note SQL 2019 in CTP3 yet) to get the latest improvements with In-Memory OLTP.
In this video, the basic idea about In-Memory OLTP and the performance improvement scripting demo is presented.
I've covered following topics in this video-
1. Basic understanding of In-Memory OLTP
2. High level Architecture
4. Performance Improvement through DEMO session
5. SQL Server 2017 In-Memory OLTP enhancements.
Videos in this series-
1. In-Memory OLTP in SQL Server 2017 - • In-Memory OLTP in SQL Server 2017
Your suggestions and comments are highly desirable. If you have any question, please feel free to write in the comment section below.
Do not forget to like, subscribe and share my YouTube channel with your friends and colleagues :)
Reference
[1] https://sqlwithmanoj.com/2017/12/20/s...
[2] https://www.sqlshack.com/memory-oltp-...
[3] https://database.guide/full-list-of-c...