In-Memory OLTP Simulator
(Community Edition - Free)

In-Memory OLTP Simulator enables you to easily test and benchmark 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, you can load data from different sources (i.e. from Production DBMS instances using Linked Servers) into the Simulator’s database and simulate real-life scenarios with the use of custom scenarios as well as get in-depth analytics on performance when utilizing Memory-Optimized Tables and Natively-Compiled Stored Procedures in SQL Server®. Furthermore, with "Benchmark Mode" which is available in all editions, you can run three basic benchmarks (update, insert and aggregation) using different parameters. The Community Edition of In-Memory OLTP Simulator provides basic functionality. The basic feature that is not enabled in the Community Edition when compared to the the Ultimate Edition, is the capability of creating custom scenarios, thus benchmarking In-Memory OLTP against your own workload. Please see the features session below for more information on which features are available in the Community Edition of In-Memory OLTP Simulator.

featuresdownloadscreenshots online helpBuy U. Editiondatasheet why we built it

  

Image

Image

Image

Why We Built In-Memory OLTP Simulator


In-Memory OLTP Engine in SQL Server 2014 (and later) came to bring a revolution to performance of OLTP operations in SQL Server. With speedups that may reach up to 100x times faster than disk-based processing, it is for sure a technology that all of us should start use. We created In-Memory OLTP Simulator in order to make the whole process easier for you. By using In-Memory OLTP Simulator's wizards and workflow-based approach, you can simulate your own workload and run it against SQL Server's In-Memory OLTP Engine, get rich statistics and insights and thus see in action how much you could benefit when using SQL Server's In-Memory OLTP for your workload types.

Community Edition Features and Limitations


App Screenshot
Custom Scenarios Limitation

In the Community Edition of In-Memory OLTP Simulator you cannot create custom scenarios via Scenario Manager and thus benchmark SQL Server's In-Memory OLTP Engine against your own workload.Please consider upgrading to the Ultimate Edition for gaining access to this feature. In the Community Edition you can only use the standard scenarios shipped with the program.


Other Limitations

- Cannot generate and use multiple simulation databases
- Cannot create, modify and run custom scenarios
- Cannot export custom scenarios
- Cannot import custom scenarios
- Cannot generate executive report
- Cannot print report
- Cannot export report
- Cannot send report in text format by email

Editions Comparison


Compare In-Memory OLTP Simulator Editions
Feature
Ultimate Edition
Community Edition
Benchmark Mode
Run Standard Scenarios
View Current Usage Statistics
Change Number of Records for Standard Scenarios
View Active Scenario Definition
View Current Resource Usage
Stop Simulation
Drop Scenario
Drop All Scenarios
Take Simulator Database Offline
Bring Simulator Database Online
Simulation Statistics
Export Statistics to Text File
Export Graphs to Image File
Print Statistics
View Schema of Tables
View Result of Simulation
Set Emergency Thresholds
Real-Time Resource Monitoring
Generate and Use Multiple Simulation Databases
Create, Modify and Run Custom Scenarios
Export Custom Scenarios
Import Custom Scenarios
Executive Report
Print Report
Export Report
Send Report in Text Format by Email
Export Scenarios and Benchmarks to DDL Scripts

Download In-Memory OLTP Simulator

Version: 1.1 (new)
Build: 20161120_1

 

What's New:

  • - Benchmark Mode
  • - Export Scenarios and Benchmarks to DDL Scripts
  • - GUI Improvements
  • - Minor Bug Fixes


You can download the Community Edition of In-Memory OLTP Simulator from the below download links:


  • [Minimum system requirements for running In-Memory OLTP Simulator]:

    Client:

    • - Architecture: 64-bit
    • - Operating System: Microsoft® Windows 7 or later x64 -or- Microsoft® Windows Server 2008 R2 or later- Logical Processors: 4
    • - RAM: 8 GB
    • Software Requirements:

     

  • Database Server (dedicated):

    • - Architecture: 64-bit
    • - Operating System: Microsoft® Windows Server 2008 R2 or later
    • - DBMS: Microsoft SQL Server 2014 (or later) x64 Evaluation, Developer or Enterprise Edition
    • - Logical Processors: 8
    • - RAM: 16GB or more (Note: This depends to the workload you are planning to use - you can test the amount of RAM needed by monitoring the resource usage when running simulations.)


    [Recommended system requirements for running In-Memory OLTP Simulator]:

    Client

    • - Architecture: 64-bit
    • - Operating System: Microsoft® Windows 7 or later x64 bit -or- Microsoft® Windows Server 2008 R2 or later
    • - Logical Processors: 8 or more
    • - RAM: 16 GB or more
    • Software Requirements:

     

  • Database Server (dedicated)

    • - Architecture: 64-bit
    • - Operating System: Microsoft® Windows Server 2008 R2 or later
    • - DBMS: Microsoft SQL Server 2014 (or later) x64 Evaluation, Developer or Enterprise Edition
    • - Logical Processors: 8 or more
    • - RAM: 32GB or more (Note: This depends to the workload you are planning to use - you can test the amount of RAM needed by monitoring the resource usage when running simulations.)


    Considerations:

    Never host In-Memory OLTP Simulator’s database on Production SQL Server® instances or Production servers. As the nature of the tool is to benchmark extreme simulations, you would risk the stability of your Production environment if you used it to host In-Memory OLTP Simulator’s database there. Use a Test server instead and in case you want to simulate Production workload you can copy the target data (i.e. via a linked server, SSIS, etc.) to the tables that will be created in Simulator’s database based on the definition of the custom scenario (custom scenarios can only be created in the Ultimate Edition of In-Memory OLTP Simulator).


    If you do not wish to use two different machines for running In-Memory OLTP Simulator (Database Server and Client PC), you can run In-Memory OLTP Simulator directly on the dedicated database server (not Production) that will be used for hosting the simulator's database(s).


Total Downloads: 658

Purchase the Ultimate Edition of In-Memory OLTP Simulator


Read the EULA


*Important Considerations

[1] A single purchased license for In-Memory OLTP Simulator's Ultimate Edition allows up to two (2) activations for different hardware configurations but only on the same computer. To this end, if you make extensive changes to your computer's hardware, you can generate a new activation code and run the activation process again. This can only take place once. This means that the after you make use of the second activation (for the same computer), you will not be provided with additional free activations in case of further hardware changes to your computer. In such case, you will need to purchase a new license for the Ultimate Edition and perform a new activation (read the EULA for more info).

[2] During the activation process, and after you enter the serial key that you were provided during your purchase of the Ultimate Edition license of In-Memory OLTP Simulator, you need to retrieve and submit to SQLArtBits an "Activation Code". The activation code is a unique hardware hash (a hash is a numeric value derived through a mathematical formula and based upon some other, original value) that is created by running 2 different pieces of information from the computer's hardware components (BIOS id, Mainboard id) through a one-way mathematical transformation. This means that the resultant hash value cannot be backwards calculated to determine the original values and it ensures complete anonymity. This process was developed in order to maintain the user's privacy and it is only used to deter piracy.

For more information and step-by-step instructions on how you can activate the Ultimate Edition of In-Memory OLTP Simulator after purchasing a license, please visit the online help topic "Special Topics: Activating the Ultimate Edition".

Last but not least you can find here In-Memory OLTP Simulator's End-User License Agreement.

Screenshots