In-Memory OLTP Performance Demo v1.0

This is the performance demo that is shown in various presentations about In-Memory OLTP. It demonstrates the performance improvements that can be obtained in SQL Server and Azure SQL Database by using memory-optimized tables and natively compiled stored procedures.

This release contains two files:

• readme.txt - Instructions for running the demo.
• InMemoryOLTPDemo.zip - Windows Forms application that simulates the workload and T-SQL scripts for demo setup.

The source code for the demo is maintained here.

Update 2016-06-07: added missing sequence to setup script
Update 2016-12-08: changed rows/transaction to 100 and index to hash, to have a more consistent perf profile across different types of hardware

For any feedback on the sample, contact: sqlserversamples@microsoft.com

References:

• In-Memory OLTP documentation
• 17-minute video explaining In-Memory OLTP and showing the demo (demo is at 8:25)