In-Memory OLTP Simulator: The Experiment

A few days ago I published a 38-page technical paper titled “In-Memory OLTP Simulator: The Experiment“. In-Memory OLTP Simulator is a software tool that we developed, which allows the user to easily simulate virtually any workload against the powerful In-Memory OLTP Engine of Microsoft SQL Server.   What Does the Paper Discuss? This paper presents … Read more…

In-Memory OLTP: Comparison of Features/Limitations between SQL Server 2014 and SQL Server 2016

In earlier articles I talked about the In-Memory OLTP Engine in SQL Server 2014. Even though it is very powerful, it had some limitations (note the past tense of “have” here as I have some good news! 🙂 For example you couldn’t use subqueries in the clauses of a SELECT statement inside a natively-compiled stored … Read more…

In-Memory Optimization in SQL Server: Will my Workload Execute Faster?

In-Memory OLTP in SQL Server 2014 or later is a powerful engine integrated into the SQL Server Engine, optimized for Online Transaction Processing (OLTP). In-Memory Optimization in SQL Server, has certain characteristics and can help increasing performance in a great number of scenarios.   A Short Description of the SQL Server In-Memory OLTP Technology If I … Read more…

In-Memory OLTP Simulator v1.0 Now Live!

After two years of heavy development, my tool “In-Memory OLTP Simulator” is finally out! In-Memory OLTP Simulator enables the IT Professional and Developer to easily test the powerful In-Memory OLTP Engine of SQL Server 2014® (or later) with different simulations and against different workloads. In the Ultimate Edition of the tool, among other, the user … Read more…

Introducing In-Memory OLTP Simulator

One of the key features originally shipped with SQL Server 2014 was the long-awaited In-Memory OLTP, codenamed as project “Hekaton”. In-Memory OLTP introduced new data structures for optimizing the performance of OLTP workloads. These data structures are called “memory-optimized” tables and along with natively compiled stored procedures, they can offer a huge performance boost when … Read more…