Skip to content

In-Memory OLTP Performance Demo v1.0

Compare
Choose a tag to compare
@jodebrui jodebrui released this 06 Jun 23:12
· 3613 commits to master since this release

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: