Great EMC Blog on Microsoft TechNet – Leveraging Flash Across the Microsoft SQL Server Stack

Our own Sam Marraccini wrote the following blog which is posted on Microsoft TechNet.  We hear from many of our customers that as their databases grow, costs increase and performance decreases.  Sam presents a very compelling case for using Flash in a SQL Server envrionment.  Enjoy his post here:

http://blogs.technet.com/b/dataplatforminsider/archive/2013/05/01/leveraging-flash-across-the-microsoft-sql-server-stack.aspx

 

The Hype v. Reality of Software Lead Storage and Windows Server 2012…Infrastructure matters to the tune of 15% lower TCO and 33% lower staff costs!

I recently read an interesting perspective on Software defined data centers and storage. The blog by David Vallente at Wikibon- entitled Windows Server 2012 Falls Short on Software-Defined Storage (http://wikibon.org/wiki/v/Windows_Server_2012_Falls_Short_on_Software-Defined_Storage). David and his team including David Floyer recently did an analysis of Windows Server 2012 and the new features such as OffLoad Data Transfer (ODX) , Storage spaces, SMB 3.0  etc. ( David Floyer’s blog -  Windows Server 2012 Falls Short on Software-Defined Storage http://wikibon.org/wiki/v/Windows_Server_2012_Falls_Short_on_Software-Defined_Storage)

The folks at Wikibon have been predicting for some time that ISVs like Microsoft (and Oracle) would increasingly try to grab more storage function and pressure traditional storage models.   

In this analysis, Wikibon conducted a number of interviews with customers that had some level of experience with Windows Server 2012.   This group represented a range of industries and account sizes.  What they found was that Microsoft Windows Server 2012 is an important and successful new release.

He further elaborates that in Wikibon’s view – “specifically as it relates to Windows Server 2012, arrays that integrate with this new platform will provide better tactical ROI in the near term.” 

But the potential challenge is in the robustness and maturity of this new functionality and deployment model.  As Wikibon further elaborates, its Windows Server 2012 lack of robustness and storage function maturity that cautions them on the true Software-led storage from Microsoft is still a release cycle or two away. Specifically, array-based storage will continue to provide the best ROI for many small and mid-sized Microsoft shops over the next 18-24 months.

In both of these cases, Wikibon’s research found that to the extent an array had the capability to exploit these new features, the value proposition of array-based storage was significantly better than relying solely on a Microsoft-led (Software-led) storage stack ( aka the do it yourself model) .   As such, the array-based capability that Wikibon modeled to evaluate the business case demonstrated significantly better value than a Microsoft Software-led approach using commodity disks . 

 What array did they use in the modeling and analysis?  The EMC VNX platform.  Wikibon further cautions folks looking at using Windows Server 2012 to ensure that their arrays can exploit the new functionality.   

Wikibon highlighted in their analysis that: 

  • Spending 10% more on disk array hardware that can exploit Windows Server 2012 capabilities can lead to 14% lower overall costs relative to today’s Microsoft Software-led approach using JBOD;
  • While server costs will be somewhat lower and largely offset more expensive array costs, the real savings come from infrastructure management costs (i.e. lower people costs).
  • By utilizing array-based hardware that can integrate with and exploit Windows Server 2012 function, IT organizations will free up staff time and reduce management complexity by approximately 33%. This can lead to better IT staff productivity and reduction in time spent doing non-differentiated heavy lifting for storage.

 Wikibon sums it up:”  Microsoft’s Windows Server 2012 delivers some compelling function, but critical storage capabilities are lacking, such that true Software-Defined Storage from Microsoft remains elusive. In the near-to-mid term, to achieve maximum efficiency IT organizations must either investigate alternative software-defined offerings or stick with array-based storage solutions that integrate with Windows 2012. Importantly, to the extent these traditional arrays exploit key new features in Windows Server 2012, business value will likely exceed all-Microsoft storage stack approach.”

No surprise here at EMC…. we agree that Windows Server 2012 is very interesting.  EMC was the first to announce our intent to deliver support ((June 2012 – http://www.emc.com/about/news/press/2012/20120910-01.htm)

; were the first storage provider to deliver support for SMB 3.0 and our award winning VNX platform was used to showcase the TechEd keynote to show case the ODX functionality.  We also are leading the pack with quite a bit of integration with Windows Server 2012 and System Center.  Let us not forget our recent announcements around VSPEX support for Windows Server 2012 as wellIn addition to checking out the Wikibon blogs, I would recommend checking out:

Everything Microsoft at EMC

 Also, there are additional assets that may help you understand the role infrastructure plays when deploying Windows Server 2012 in a Private Cloud Environment.  More information can also be found on emc.com

EMC Perspective:  The Power of Windows Server 2012 and EMC Infrastructure – http://www.emc.com/collateral/emc-perspective/power-windows-server-2012-emc-infrastruction-ms-pce.pdf

Whitepaper: EMC VNX3 Introduction to SMB 3.0 – http://www.emc.com/collateral/white-papers/h11383-vnxe-introduction-wp.pdf

There is a wealth of opportunities at #EMCworld to learn more about EMC and Windows Server 2012.   I am also looking forward to talking with the Wikibon folks at EMCworld to learn more about their analysis. 

Hear the Customer Perspective on Why EMC VNX is a Great Option for Microsoft Environments

Customers of all sizes – across all industries – are seeing tangible benefits of using VNX as their storage platform of choice for Microsoft environments.   VNX provides a multitude of benefits for Microsoft environments by providing automated and economical unified storage with pace-setting performance, optimized for virtual applications.  It’s easy for EMC to promote the benefits of our technology…we work with it all the time.  But its even more interesting to hear from actual customers who have deployed VNX and our management solutions on how EMC has helped them to achieve their IT and business objectives.  

Watch European and American companies discuss the increased performance and management simplicity of running their Microsoft applications on EMC VNX unified storage.

http://www.emc.com/collateral/demos/microsites/mediaplayer-video/emc-customers-microsoft-applications-emc-vnx.htm

Whats in your SLA?

People have been considering and comparing public (hosted) and private (on-premises) cloud solutions for some time in the messaging world, and at increasing rates for database and other application workloads.  I’m often surprised at how many people either don’t know the contents and implication of their service provider service level agreement (SLA), or fail to adjust the architecture of private cloud solution and then directly compare cost. 

Here are my five lessons for evaluating SAAS, PAAS, and IAAS provider SLAs:

Lesson 1: Make sure that what’s important to you is covered in the SLA

Lesson 2: Make sure that the availability guarantee is what you require of the service

Lesson 3: Evaluate the gap between a service outage’s cost to business and the financial relief from the provider

Lesson 4: Architect public and private clouds to the similar levels of availability for cost estimate purposes

Lesson 5: Layer availability features onto private clouds for business requirement purposes

I’ll use the Office 365 SLA to explore this topic – not because I want to pick on Microsoft,  but because it’s a very typical SLA, and one of the services it offers (email) is so universal that it’s easy to translate the SLA’s components into the business value that you’re purchasing from them.

Defining availability

The math is simple.  It’s a 99% uptime guarantee with a periodicity of one month:

image

If that number falls below 99, then they have not met their guarantee.  For what it’s worth, during a 30 day month, the limit will be about 44 minutes of downtime before they enter the penalty, or about 8.7 hours per year.

But what does “Downtime” mean?  Well, it’s stated clearly for each service.  This is the definition of downtime for Exchange Online:

“Any period of time when end users are unable to send or receive email with Outlook Web Access.”

Here’s what’s missing:

  • Data:  The mailbox can be completely empty of email the user has previously sent and received.  In fact the email can disappear as soon as they receive it.  As long they can log in via OWA, the service is considered to be “up”.
  • Clients:  Fat outlook, blackberry, and Exchange ActiveSync (iPhone/iPad/Winmopho, and most Android) clients are not covered in any way under the SLA

Lesson 1: Make sure that what’s important to you is covered in the SLA

Lesson 2: Make sure that the availability guarantee is what you require of the service

Balancing SLA penalties with business impact

My Internet service is important to me.  When it’s down, I lose more productivity than the $1/day or so I spend on it.  Likewise, email services are probably worth more than the $8/month/user or so that you might pay your provider for it.  That doesn’t mean that you should spend more than you need for email services.  But it does mean that if you do suffer an extended or widespread outage, there will likely be a large gap between the productivity cost of the downtime and the financial relief you’ll see in the form of free services you’ll see from the provider. 

image

Callahan Auto Parts also offers a guarantee

I’ll put this in real numbers.  Let’s say I have a 200 person organization.  I might pay $1600/month for email services from a provider.  If my email is down for a day during the month, my organization experiences 96% uptime for that month, and as a result, my organization is entitled to a month of free email from the provider, worth about $800.

image

The actual cost of my downtime will very likely exceed $800.  To calculate that cost we need the number of employees, the loaded cost per hour for the average employee, and and the productivity cost of the loss of email services.  For our example of 200 employees, let’s imagine a $50/hour average loaded cost to business and a 25% loss of productivity when email is down:

200 employees x $50 cost per hour x .75 productivity rate x 8 hour outage = $60,000 of lost productivity

Subtract the $800 in free services the organization will receive the next month, and the organization’s liability is $59,200 for that outage.

Now how do you fill that gap?  I’m not entirely sure.  It could be just the risk of doing business – after all, the business would just absorb that cost if they were hosting email internally and suffered an outage.  If the risk and impact were large enough, I would probably seek to hedge against it – exploring options to bring services in house quickly, or even looking to an insurance company to defray the cost of outages – if Merv Hughes can insure his mustache for $370,000, then surely you can insure the availability of your IT services.  Regardless, it’s wise not to confuse a “financially backed guarantee” with actual insurance or assurance against outage.

File Photo:  What a $370k mustache may look like.  Strong.

Lesson 3: Evaluate the gap between a service outage’s cost to business and the financial relief from the provider

Comparing Apples to Oranges

image

See what I did there?

Doing a cost comparison between public cloud designed to deliver 99.9% availability and a private cloud designed to provide 99.99% or 99.999% availability makes little sense, but I see people do it very frequently.  Usually it’s because the internal IT group’s mandate is to “make it as highly available as possible within the budget”.  So I’ll see a private cloud solution with redundancy at every level, capabilities to quickly recover from logical corruption, and automated failover between sites in the event of a regional failure, compared to a public cloud solution that provides nothing but a slim guarantee of 99.9% availability.  In this instance, it’s obvious why the public cloud provider is less expensive, even without factoring in efficiencies of scale.

To illustrate this, I usually refer to Maslow’s hand-dandy Hierarchy of Needs, customized for IT high availability.

image image

Single Site and Multi-site Hierarchies of Need

If I want to make an accurate comparison between a public cloud provider’s service and pricing and what I can do internally, I often have to strip out a lot of the services that are normally delivered internally.  Here’s the steps:

  1. Architect for equivalence.  If I have a public cloud provider just offering 3 9’s and no option for site to site failover, for my database services, I might just do a standalone database server.  Maybe I’d add a cheap rapid recovery solution (like snapshots or clones) to hedge against compete storage failure and cluster at the hypervisor layer to provide some level of hardware redundancy.  If my cloud provider offers disaster recovery, I’d figure out what their target RPO/RTO and insert some solution that matches that capability.
  2. Do a baseline price comparison.  Once I’ve got similar solutions to compare, I can compare price.  We’ll call this the price of entry.
  3. Add capabilities to the private cloud solution after the baseline.  I only start layering features that add availability and flexibility to the solution after I’ve obtained my baseline price.  Only then can I illustrate the true cost of those features, and compare them to the business benefits.

Lesson 4: Architect public and private clouds to the same levels of availability for cost estimate purposes

Lesson 5: Layer availability features onto private clouds for business requirement purposes

Microsoft SQL Server, EMC Symmetrix VMAXe and EMC Isilon Enable Dramatic Gains in Performance and Scalability for Industry Leading Auction website

Heritage Auctions is the world’s largest collectibles auctioneer and third largest auction house in the world.  The company has seen its inventory and bidding volumes increase significantly in recent years, and has extensively incorporated online bidding and video into the auction process.  Due to these factors, the amount of data – including photos of collectibles and online video – that Heritage Auctions must manage daily has grown exponentially.

Hear from Brian Carpenter, Vice President of Information Technology, Heritage Auctions, on how EMC and Microsoft are helping to address these challenges.

http://www.emc.com/collateral/demos/microsites/mediaplayer-video/heritage-auctions-emc.htm