Accelerate SQL server 2012 OLTP database performance with Dell fluid cache for SAN

Accelerate SQL server 2012 OLTP database performance with Dell fluid cache for SAN


Organizations are looking to deploy virtual servers in the effort to reduce IT costs and increase data center performance. Microsoft SQL Server is a popular database product that is widely used by business applications. As SQL Server is an I/O intensive workload, deploying it in a virtualized environment may limit database performance due to storage I/O bottlenecks.

Many organizations have begun to replace rotational hard drives with solid state drives (SSDs) that have the benefit of increased performance, a small form factor and low power consumption. Even if you replace rotational hard drives with SSDs, the key to increasing application performance is not so simple. Adding SSDs you upgrade the hardware of your organization. Even then, network latency or contention at the array ports impacts performance adversely.

Dell Fluid Cache for SAN is a highly available write-back server-side caching accelerator that utilizes high-speed PCIe-SSDs as a shared, caching solution with an "open" compute cache pool layer. Fluid Cache for SAN runs in a flexible and low-latency Dell Compellent™ SAN environment. The key differentiation of Fluid Cache for SAN from other host side caching solutions are the global cache pool across multiple servers, the read and write-back cache policies, and the easy access media.

This white paper helps you configure the Dell Fluid Cache for SAN solution and demonstrates how the performance of an online transaction processing (OLTP) database can be accelerated using this solution compared to the rotational hard drives-based solution.

Key takeaways:
OLTP
Figure 1: Key Takeaways

For more details, please go through the white paper:
http://downloads.dell.com/solutions/enterprise-solution-resources/PowerEdge%20R920%20SQL%20High%20Performance%20and%20Consolidation.pdf




Article ID: SLN310991

Last Date Modified: 08/14/2018 02:50 PM


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.