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 a series of simulations for a specific scenario against different workload sizes. The paper discusses the findings of these simulations by describing how the entire process was designed using In-Memory OLTP Simulator, as well as by observing and analyzing the performance trends after executing the different versions of the scenario against SQL Server’s In-Memory OLTP Engine.

The highlight of the paper is the fact that for a workload of 5M records, I achieved breakthrough performance with a speedup of 26x over disk-based tables!

You can download the paper here.

 

Enroll to the Online Course!

Enroll to our online course titled  “Boost SQL Server Database Performance with In-Memory OLTP” and learn how to harness the power of SQL Server’s In-Memory Optimization and Boost the Performance of your Data Processes!

Boost SQL Server Database Performance with In-Memory OLTP - Online Course
(Lifetime Access, Downloadable Resources, Certificate of Completion, and more)

Learn More

 

*Update: You can download the free 14-day trial of In-Memory OLTP Simulator here. In-Memory OLTP Simulator is now part of SQLNetHub’s software collection.

 

In-Memory OLTP Simulator - SQLNetHub
Start Page

 

In-Memory OLTP Simulator - Simulation Statistics Page
Simulation Statistics Page

 

Featured Online Courses:

 

Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHub TV)

Check out our latest software releases and eBooks!

Easily generate SQL code snippets with Snippets Generator!

Convert static T-SQL to dynamic and vice versa with Dynamic SQL Generator.

Secure your SQL Server instances with DBA Security Advisor.

Benchmark SQL Server memory-optimized tables with In-Memory OLTP Simulator.

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)

Loading...

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub