In-Memory OLTP Simulator

In-Memory OLTP Simulator

Easily Benchmark Any Workload Against SQL Server In-Memory OLTP

With In-Memory OLTP Simulator you can easily benchmark standard and custom scenarios of data workloads and processing against the powerful In-Memory OLTP Engine in SQL Server, get rich analytics and insights, and see how Memory Optimization in SQL Server can help you boost the performance of your data processes.

List of Features

  • Compare Disk-Based vs Memory-Optimized vs Memory-Optimized with Natively-Compiled Stored Procedure Execution Modes
    • This comparison is the main philosophy behind In-Memory OLTP Simulator. you get this comparison for all scenarios and Benchmark Mode. The Ultimate Edition offers even more insights regarding the comparison results.
  • Standard Database Workload Scenarios
    • Run and change workload of six standard database process scenarios shipped with the tool (available in both Editions).
  • *Custom Scenarios
    • In the Ultimate Edition, you can create your own custom scenarios, and thus simulate and compare the execution times for just about any database workload.
  • *Executive Report
    • In the Ultimate Edition of In-Memory OLTP Simulator, the user can generate an executive report regarding the simulation statistics and use it to better present her or his findings to Management.
  • *Rich Set of Export Options (Ultimate Edition)
    • In the Ultimate Edition of In-Memory OLTP Simulator, you are presented with a rich set of export options for simulation statistics, executive report and scenario definitions.
  • Datasheet
    • Get the datasheet for a full list of features and comparison of the Ultimate and Community Editions.
* This set of features is available only in the Ultimate Edition of In-Memory OLTP Simulator. 

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.

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

 

 


What’s New and System Requirements

Latest Version: 1.2

Version Information:

  • Release number: 1.2
  • Build number: 20180306_1
  • Release date: March 08, 2018

What’s new:

  • GUI enhancements
  • Minor bug fixes
  • Added Support for SQL Server 2017

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).


Download Trial Version (Community Edition)

The trial version of In-Memory OLTP Simulator, is actually a Community Edition, which allows you to use Benchmark Mode, as well as run standard simulation scenarios that ship with the tool. The set of unlocked features in the Community Edition In-Memory OLTP Simulator, can help you assess standard workload against the powerful In-Memory OLTP Engine of SQL Server. Moreover, you might consider purchasing the Ultimate Edition of In-Memory OLTP Simulator and thus be able to create your own simulations, get more insights for your simulations, and much more!

Download In-Memory OLTP Simulator 1.2 (Community Edition):

* In-Memory OLTP Simulator, up to version 1.1 was released under the brand name “SQLArtBits”.


Purchase the Ultimate Edition of In-Memory OLTP Simulator

Purchase the Ultimate Edition of In-Memory OLTP Simulator and unlock all features.

Price for single license: $24.95

Purchase In-Memory OLTP Simulator Ultimate Edition License

SSL Connection

Help Topic: How to activate the Ultimate Edition

 

*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 SQLNetHub 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.

 

(coming soon)


Screenshots of In-Memory OLTP Simulator

 

coming soon

 

 

 


Recommended eBooks

Developing with SQL Server (eBook)

Title: Developing with SQL Server (Second Edition)
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, MVP

Learn how you can efficiently program in SQL Server. Learn about different T-SQL constructs and get useful T-SQL tips. Learn how you can work with unstructured data, data access and more.

Price: $39.99

Learn More | Buy Online

 

Administering SQL Server (eBook)Title: Administering SQL Server (Second Edition)
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, MVP

Learn how to effectively administer your SQL Server databases. Learn about maintenance, security, integration, error handling and more.

Price: $39.99

Learn More | Buy Online

 

 

Tuning SQL Server (eBook)Title: Tuning SQL Server (Second Edition)
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, MVP

Learn how you can tune SQL Server and get the most of it when it comes to performance. Learn about indexes, log files management, locking, blocking and more.

Price: $39.99

Learn More | Buy Online

 


Other Recommended Software Tools


Rate this tool: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Loading...