Accelerate SQLserver 2014 IN-MEMORY OLTP performance with Dell PowerEdge R920 and NVMe PCIe flash cards

Accelerate SQLserver 2014 IN-MEMORY OLTP performance with Dell PowerEdge R920 and NVMe PCIe flash cards


Today’s Online Transaction Processing (OLTP) based applications such as online reservations, stock market, and process control need real-time access to data. The traditional disk-based OLTP systems cannot keep up with the requirements of today’s applications, therefore, there is a continuous requirement for alternate low- cost OLTP systems that can deliver higher throughput at lower latency.

By leveraging the modern hardware trends and recent technology advancements, many of the software vendors introduced several In-Memory OLTP systems to the market. SQL Server 2014 In-Memory database is one such product from Microsoft®. It is a high performance OLTP database engine that is designed and optimized for processing In-Memory data.

This technical white paper will explore the Microsoft SQL server 2014 In-Memory database feature and showcase the performance benefits that can be achieved by deploying it on the Dell PowerEdge R920 server and NVMe-based PCIe flash drives. You are presented with guidelines and best practices for configuring SQL Server 2014 In-Memory databases and the test results that were conducted at Dell Labs.

The key results of this white paper are shown in the snapshot here.
OLTP Performance
Figure 1: OLTP




Article ID: SLN310994

Last Date Modified: 08/16/2018 08:12 AM


Rate this article

Accurate
Useful
Easy to understand
Was this article helpful?
Yes No
Send us feedback
Comments cannot contain these special characters: <>()\
Sorry, our feedback system is currently down. Please try again later.

Thank you for your feedback.