Microsoft SQL Server Xtrem Performance and Xtrem Efficiency with XtremIO


EMCs Microsoft Solutions Team recently released a white paper highlighting the benefits of XtremIO combined with Microsoft SQL Server 2012/2014 running in a VMware vSphere environment. Xtrem Performance.  It also represents a crossroads for me personally; after all, I started my blogging over at focused on the EMC/Microsoft Partnership. What better way to come full circle than with an Xtrem performance and efficiency white paper.

Looking at common challenges seen by Microsoft SQL Administrators, how can XtremIO accelerate database performance and enable consistent predictable performance at scale while enabling additional functionality?

SQL Server XtremIOLet’s start with performance. Flash is fast, that’s a given, and I’ve blogged about that many times. Delivering consistent performance at scale can be the challenge. XtremIO Scale-Out Architecture proved to deliver consistent sub millisecond latency, consistently and predictably, regardless of how busy the system is and regardless of capacity utilization. XtremIOs unique In-Memory Architecture also proved to deliver additional performance and capacity linearly, ensuring that all X-Bricks in the configuration maintained the same low consistent latency, a key attribute to enable Flash.

Validating performance was a key attribute of the recent whitepaper. Using a standard TPC-E workload (Financial Market Simulation) a single database easily generated 15,000 IOPS at 700 Microsecond (0.7Millisecond) Latency. Remember, that’s with all data services turned on (Thin Provisioned, Protected, Deduplication and Compressed!) That’s the power of In-Memory Metadata. Add 4 more databases (5 total), 57,0000 IOPS, 5 more (10 total) 160,000 IOPS. 11 Hours later… still 160,000 IOPS latency sub millisecond – and that’s NOT “average” latency. That’s Linear Scale! Here is a quick video showing the results of the performance test.

XtremIO, Microsoft SQL Server Performance Test

Performance… Check! What about enhanced efficiencies for Microsoft SQL Server? One of XtremIOs value props is the efficiencies enabled by its in-line data services. Services like Deduplication and Compression that are always-on, always-inline and always in memory, designed to extend the life of Flash and maintain consistent predictable performance. Add to that Writeable Snaps capable of creating many copies of your production database with a small storage footprint (Deduplication/Compression) all maintaining the same performance of production (In-Memory Metadata); thus providing the ability to consolidate the most complex database designs, think test/dev, data warehousing, business intelligence and application workloads environments. That alone has the ability to change the way you design your databases and deploy your applications. Every copy of your database gets the same performance as production, without impacting performance of production. Add to that the fact that Deduplication Rates and Compression will reduce your overall footprint 10 fold (depending on the number of copies). The second demonstration highlights the efficiencies enabled by XtremIO.

XtremIO, Microsoft SQL Server Efficiently Test

Performance… Check! Efficiencies… Check! What about efficiencies and performance or snapshots at full production performance without impacting production? That’s exactly what the third test was designed to prove, and yes, we proved it!

XtremIO, Microsoft SQL Server Efficiently at Performance Test

Download the full whitepaper here!

Get all the latest at and follow me on twitter @SamMarraccini

Continue Reading
Would you like to read more like this?

Related Posts

Click to Load More
All comments are moderated. Unrelated comments or requests for service will not be published, nor will any content deemed inappropriate, including but not limited to promotional and offensive comments. Please post your technical questions in the Support Forums or for customer service and technical support contact Dell EMC Support.