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.

 

Get the Free 30-Day Trial

 

Buy the Ultimate Edition!

 


In-Memory OLTP Simulator’s Key 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.
* This set of features is available only in the Ultimate Edition of In-Memory OLTP Simulator. 

 

 


Why we Built In-Memory OLTP Simulator and How Can it Help You?

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, and for us too! 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

Free 30-Day Trial
$0
Expires After 30 Days
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
 
 
 
 
 
 
 
 
 
 
Ultimate Editon
$39.99
No Time Limitations
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
Free Lifetime Updates

 


What’s New and System Requirements

Latest Version: 1.2

Version Information:

  • Release number: 1.2
  • Build number: 20180908_1
  • Release date: September 08, 2018

What’s new:

  • Minor bug fixes
  • Performance Improvements

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 Free 30-Day Trial Version

The trial version of In-Memory OLTP Simulator, allows you to use Benchmark Mode, as well as run standard simulation scenarios that ship with the tool. The trial version has limited functionality and expires 30 days after the first use of the tool. Using the free 30-day trial of In-Memory OLTP Simulator, you can assess and run basic 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 (Free 30-Day Trial Version):

* 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 and limitations.

Features you get with the Ultimate Edition:

  • Create, modify and use custom scenarios
  • Executive report
  • Export scenarios and benchmarks to DDL scripts
  • No functionality limitations
  • No time limitations
  • Free lifetime updates
  • …and more!

Price for single license: $39.99

Purchase In-Memory OLTP Simulator Ultimate Edition License

SSL Connection

Help Topic: How to activate the Ultimate Edition

* For order-related help, you can reach us via the contact page.

 

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

 


Screenshots of In-Memory OLTP Simulator


Recommended eBooks with Relevant Knowledge Offerings

Developing with SQL Server (eBook)

Title: Developing with SQL Server (Second Edition)
Author: Artemakis Artemiou, B.Sc., M.Sc., MCP, MCTS, MCITP, Former Microsoft Data Platform MVP (2009-2018)

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, Former Microsoft Data Platform MVP (2009-2018)

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, Former Microsoft Data Platform MVP (2009-2018)

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 (1 votes, average: 5.00 out of 5)

Loading...