To redefine means you have to deliver increased IT agility.  By implementing EMC technologies, customers just like you have redefined their IT environments - experiencing 5X faster deployments and 4X less staff time and driving the overall cost 3X lower.  What’s more – with EMC Converged solutions, the process is repeatable and heavily automated; the Microsoft application availability increased 83X.  EMC solutions include VCE, VBLOCK and VSPEX to deliver tried and tested solutions for Microsoft environments.

 

EMC’s infrastructure products, services, and integration points provide improved productivity, eliminate risk, transform IT and maximizes the customer IT investment for Microsoft applications and SQL Server environments. Businesses are facing new, tougher IT challenges, as their customers and end-users become more demanding.  Business customers running Microsoft applications now require greater access to data on more platforms for more hours of the day. Many businesses struggle to provide the solutions their customers want.  Not to worry…. EMC enables you to satisfy your Microsoft SQL Server requirements through innovative products, services, and support options that work together to create end-to-end solutions.

 

Check back often to learn how you can leverage the latest SQL Server functionality with robust EMC Infrastructure solutions Microsoft SQL Server and Applications Infrastructure Redefined.

 

 

Screen+Shot+2014-05-01+at+2.40.56+PM.png


EMC's SQL Server 2014 Story

The rapid evolution of the SQL Server platform means that customers will be looking to EMC to provide advice on the infrastructure to support SQL Server and the applications that run on top of it.  Here is what’s most likely to impact our conversations around SQL Server:

 

Apppppp.JPG.jpg

 

Self Service SQL Protection for DBAs

EMC's AppSync makes it easy for DBAs to manage protection of SQL Server databases, independent of the storage system. Learn more about how to provide SLA-driven, self service capabilities for maximizing and simplifying data protection and reliability.

 

 

sqlvid2.png

Why EMC for SQL Server 2012 Video

With explosive data growth for both structured and unstructured data types, customers need real time decision making and business intelligence with high performance and availability protection.  Watch this short video to learn how EMC provides comprehensive solutions to gain the maximum benefits of Microsoft SQL Server 2012.

 

 

 

EMC Solutions for SQL Server 2012

 

sqlsolutions.pngLearn how EMC technologies can assist a Microsoft SQL Server and infrastructure administrator through simple and easy to use management and protection of data. EMC tools such as Unisphere and EMC Storage Integrator (ESI) are demonstrated to highlight how easy it is to manage an EMC array in a Microsoft environment. EMC's AlwaysOn Availability Groups are highlighted to help ensure failover of SQL databases between SQL nodes. Finally, performance improvements can be realized through the use of EMC's FAST Cache including performance metrics highlighting the advantages of using EMC FAST Cache with a Microsoft SQL Server workload.

 

 

 

 

 

ESG.pngThis Enterprise Strategy Group (ESG) Whitepaper discusses the new features found in Microsoft SQL Server 2012 and key EMC technologies that assist SQL and infrastructure administrators for improved performance, scalability, data protection and services. Technologies discussed includes EMC VNX and VMAXe; Fully Automated Storage Tiering (FAST) including EMC FAST VP, FAST Cache and VFCache; Backup and Deduplication; AlwaysOn High Availability; and EMC Consulting Services for Business Intelligence (BI) and Microsoft SQL Server

 

 

 

 

 

multisiteDRsql.png

SQL Server 2012 AlwaysOn Availability Groups provide the flexibility to protect specific databases, individually or collectively, in either synchronous or asynchronous availability modes. These configurations allow SQL Server 2012 the ability to replicate data to a secondary replica over distance.

 

This solution clearly shows the ability of EMC FAST Cache to significantly boost performance of the VNX Series storage array. Testing shows how enabling FAST Cache on a heavily utilized storage pool not only alleviated pressure, but allowed the same storage pool to service over four times the I/O (from 11,500 IOPS to 50,000 IOPS), while returning incredibly low SQL Server datafile average latencies times of 3 ms and less for reads and writes. The ability of FAST Cache to automatically react to the changes in OLTP workload I/O patterns is an invaluable tool for administrators.

 

 

 

 

 

 

 

 

Alwayson.png

SQL Server AlwaysOn Availability

 

SQL Server 2012 introduces two high availability configurations as part of SQL Server AlwaysOn, which provides availability at either the application database or instance level:

  • AlwaysOn Failover Clustering
  • AlwaysOn Availability Groups

 

Visit this overview page to learn more about Microsoft's new high availability configurations and EMC's support and integration for Microsoft SQL Server AlwaysOn!

 

 

 

 

 

 

 

 

throughput.png

EMC FAST Cache with SQL Server 2012

 

The testing of this solution validated the ability of the VNX5700 storage array to support SQL Server 2012 in instances running OLTP-like workloads that generated over 50,000 IOPS.

 

 

 

 

 

 

 

Customer Success Stories

 

 

brainshark.pngLearn how EMC helps meet the performance needs for Brainshark’s cloud offering based on Microsoft SQL Server.
ha.pngThe world's largest collectibles auctioneer, Heritage Auctions uses EMC to enable dramatic gains in performance and scalability for Big Data using Microsoft SQL Server.
loomis.pngInternational cash handling leader Loomis uses EMC to help manage their rapid growth of mission-critical applications such as Microsoft SQL Server for data mining and Business Intelligence including significantly reducing backup windows.
ht.pngHawaii's leading communications provider brought in EMC Consulting to use Microsoft SQL Server Integration Services (SIIS) to stream performance data to a SQL Server Analysis Services cube and present the data in a dashboard using Microsoft SharePoint Portal.
crutch.pngEMC helps electronics retailer Crutchfield deploy key Microsoft applications such as Microsoft SQL Server in a Hyper-V based Private Cloud.
      edgenetlogo_footer.pngSoftware provider trust its Big Data business to EMC and Microsoft and manages terabytes of virtualized SQL Server databases.

 

 

Consulting

Overcoming the Barriers to Business Intelligence Success

ESG Research: EMC Consulting Big Data Advisory Service

Consulting Services for Microsoft SQL Server

Full list of Enterprise Information Management Consulting Offerings

 

 

More Information

Follow the Everything Microsoft at EMC Community for up to date discussions, documents and other information!