In-Memory OLTP Database Demo Tool for Database ProfessionalsCase Study

In-Memory OLTP introduced memory-optimised tables and natively compiled stored procedures, delivering substantial throughput and latency gains for suitable workloads. However, the benefits were being communicated mainly through slide decks and whitepapers, and theoretical explanations did not convince database teams who had heard performance claims before.

Sales engineers needed a repeatable way to show the difference live, in front of customers, without building a bespoke lab for every meeting. The demonstration had to be accurate, configurable for different scenarios and visually clear to both technical and executive audiences.

There was also a gap between the demo and further learning: once interest was sparked, attendees had no easy route to supporting documentation or a record of the results they had just seen.

PapaSiddhi Technologies built an interactive, web-based benchmarking tool with a React front end and a Node.js orchestration layer driving workloads against SQL Server through the Microsoft SQL Server APIs. The same transactional workload runs side by side against traditional disk-based tables and memory-optimised tables, so users can see a like-for-like live performance comparison.

Real-time throughput and latency visualisations chart transactions per second and response times as tests run. Configurable test parameters, such as concurrency, batch size and workload type, allow presenters to tailor scenarios to a customer's environment, while interactive guided workflows walk less experienced users through each step and explain what they are seeing.

At the end of a session, users can download performance reports to share internally, and integrated links to technical documentation connect each scenario to deeper guidance on implementing In-Memory OLTP.