Archive for the ‘Microsoft SQL Server’ Category

Inside Flash Episode #23: XtremIO Oracle Database Consolidation

Sam Marraccini

Sam Marraccini

Director, EMC Global Portfolio Messaging at EMC Corporation
Sam Marraccini is a 17-year EMC veteran and 26-year technology veteran. Part of EMCs Global Portfolio Marketing Team, Sam is focused on the EMCs Storage Strategy and developing messaging to support the storage portfolio. The Global Portfolio Marketing team is responsible for developing and delivering customer messaging across the full EMC product portfolio. In addition to developing the Global Portfolio Storage messaging, Sam's passion and drive continue to be demonstrated in multiple blogs including: The Source "TheSourceBlog.emc.com" and www.insideflash.com (All things flash at EMC). Flash and Microsoft information can be found at www.youtube.com/sammarraccini and Twitter @SamMarraccini (www.twitter.com/SamMarraccini)
Sam Marraccini
Sam Marraccini

XtremIO Oracle Database Consolidation with Sam Lucido: When the EMC Global Solutions Team set out to demonstrate the Oracle Database consolidation capabilities of XtremIO, they had three primary goals.

  • Simplify database consolidation – consolidate mixed-workload, test/dev with performance at scale.
  • Maximize DBA Productivity – simplify provisioning, reduce downtime and accelerate testing
  • Gain greater business insight – Run faster, more queries, more users, more value to business.

The resulting whitepaper, Oracle Database Consolidation with XtremIO  provides details on the configuration, architecture and software featured leveraged in the testing, including: Inline Data Reduction, Thin Provisioning, inline data compression and snapshots.   I had the opportunity to talk to Sam Lucido about the results of the whitepaper, XtremIO Oracle, at EMC World 2015.  Sam is a fellow EMC Elect Member, and I spotted him hanging out in the EMC Elect lounge and grabbed my camera.  Don’t forget to check out the DBA Society www.emc.com/DBASociety.

Inside Flash #23 – Thanks for Watching!

Thanks for Watching, Get all the latest at www.insideflash.com and follow me on twitter @SamMarraccini

samandsam XtremIO Oracle

Sam Marraccini and Sam Lucido talk XtremIO and Oracle at EMC World 2015 #EMCElect

Hanging out with the beast after theEMC World 2015 Launch

Hanging out with the beast after theEMC World 2015 Launch

Microsoft SQL Server Xtrem Performance and Xtrem Efficiency with XtremIO

Sam Marraccini

Sam Marraccini

Director, EMC Global Portfolio Messaging at EMC Corporation
Sam Marraccini is a 17-year EMC veteran and 26-year technology veteran. Part of EMCs Global Portfolio Marketing Team, Sam is focused on the EMCs Storage Strategy and developing messaging to support the storage portfolio. The Global Portfolio Marketing team is responsible for developing and delivering customer messaging across the full EMC product portfolio. In addition to developing the Global Portfolio Storage messaging, Sam's passion and drive continue to be demonstrated in multiple blogs including: The Source "TheSourceBlog.emc.com" and www.insideflash.com (All things flash at EMC). Flash and Microsoft information can be found at www.youtube.com/sammarraccini and Twitter @SamMarraccini (www.twitter.com/SamMarraccini)
Sam Marraccini
Sam Marraccini

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 www.insidethepartnership.com 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 insideflash.emc.com and follow me on twitter @SamMarraccini

Inside Flash Episode #8: VFCache & Microsoft SQL Server (Active/Passive) Cluster

Sam Marraccini

Sam Marraccini

Director, EMC Global Portfolio Messaging at EMC Corporation
Sam Marraccini is a 17-year EMC veteran and 26-year technology veteran. Part of EMCs Global Portfolio Marketing Team, Sam is focused on the EMCs Storage Strategy and developing messaging to support the storage portfolio. The Global Portfolio Marketing team is responsible for developing and delivering customer messaging across the full EMC product portfolio. In addition to developing the Global Portfolio Storage messaging, Sam's passion and drive continue to be demonstrated in multiple blogs including: The Source "TheSourceBlog.emc.com" and www.insideflash.com (All things flash at EMC). Flash and Microsoft information can be found at www.youtube.com/sammarraccini and Twitter @SamMarraccini (www.twitter.com/SamMarraccini)
Sam Marraccini
Sam Marraccini

VFCache 1.5 was introduced back in September 2012, an eternity in the ever evolving “Flash” marketplace. In fact, VFCache 2.0 is only a few months away. VFCache 2.0 software has some exciting new enhancements, some that will take EMC Flash Caching to the next level and beyond. For more on VFCache 2.0 stay tuned to http://insideflash.emc.com.

Before I start to highlight Version 2.0, I wanted to make sure a feature of VFCache 1.5 wasn’t overlooked. I talked about the headline items back in Episode #5 (Larger capacity, in-line deduplication and VMware vMotion support.) In addition to those major enhancements, we also introduced support for Active/Passive Cluster Environments.

I spent some time with Ye Tao, in the EMC Emerging Technology Center to review that support. Ye configured a Microsoft SQL Server Cluster (active/passive) running an active OLTP (TPC-E) workload using EMC VFCache Hardware and Software. Ye then initiated a failover and failback with no disruption of the SQL services.

Inside Flash Episode #8 highlights that demonstration:

For more details can be found at the link below. http://www.emc.com/collateral/hardware/white-papers/h10738-perfrmnce-aclrtion-sqlsrvr2012.pdf

Questions? You can e-mail me directly at sam.marraccini@emc.com, and look for me in “The Flash Zone” at EMC World 2013!

Thanks for watching insideflash.emc.com.

Questions/Comments? Contact me directly at sam.marraccini@emc.com and thanks for watching insideflash.emc.com

Inside Flash Episode #7: VFCache High Performance Microsoft SQL Server

Sam Marraccini

Sam Marraccini

Director, EMC Global Portfolio Messaging at EMC Corporation
Sam Marraccini is a 17-year EMC veteran and 26-year technology veteran. Part of EMCs Global Portfolio Marketing Team, Sam is focused on the EMCs Storage Strategy and developing messaging to support the storage portfolio. The Global Portfolio Marketing team is responsible for developing and delivering customer messaging across the full EMC product portfolio. In addition to developing the Global Portfolio Storage messaging, Sam's passion and drive continue to be demonstrated in multiple blogs including: The Source "TheSourceBlog.emc.com" and www.insideflash.com (All things flash at EMC). Flash and Microsoft information can be found at www.youtube.com/sammarraccini and Twitter @SamMarraccini (www.twitter.com/SamMarraccini)
Sam Marraccini
Sam Marraccini

Happy New Year… A year ago we were talking about EMC Project Lightning. Since then Project Lightning, now VFCache, has been introduced, providing Turbocharged Performance, Automated Intelligence and Enterprise-Class Protection. VFCache 1.5
was released in August, the first Server Flash Cache solution to deliver in-line deduplication and VMware vMotion support. (The only Flash Cache vMotion on the VMware HCL).

That momentum will not only continue, but accelerate in 2013. VFCache 2.0, VFStore and Project “X” – It’s going to be a great year. Get the latest by following www.InsideFlash.com.

The EMC Solutions Group recently released a whitepaper focused on EMC Infrastructure for VMware. The solution includes real world database workloads. Data warehouse and OLTP, Microsoft SQL and Oracle, all virtualized. A configuration that reflects what our customers are doing as they move to the cloud. A key component of that configuration is EMC VFCache, accelerating both the Data warehouse and OLTP environments.

In keeping with one of my goals of www.InsideFlash.com (and www.InsideThePartnership.com) I
spent some time with the engineer behind that whitepaper. Turns out, they did more testing than was documented in the whitepaper. Check out Inside Flash episode #7 for all the details.

Recent Comments

    Archives