Microsoft SQL Server and Applications Infrastructure Redefined

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!

 

 

Mobilize SharePoint with Syncplicity

End users love file sync and share utilities – it helps them do their jobs efficiently.  Enterprises love their Enterprise Content Management (ECM) infrastructure – they enable compliance with any number of data governance and  eDiscovery regulations and policies.  Wouldn’t it be great if you didn’t have to choose?  Wouldn’t it be great if you could bring your end users the functionality they want while retaining the ECM functionality you’ve already invested in?

Some folks will just invest in a new service to provide that sync and share functionality, then figure out how to apply their data governance policies.  This approach has a couple of pitfalls:

  • File collaboration is just one of the applications that ECMs like SharePoint support, and integration between file collaboration and other applications provides significant value.
  • Enterprises have real data governance needs, whether it’s DLP, legal compliance, eDiscovery, HIPAA or any number of other requirements.  Many enterprises have built their data governance models around ECMs they already have in place.  Re-establishing data governance capabilities around a specific service can be difficult (or impossible), and introduces path dependency to a particular service.   Nobody likes lock-in.

With Syncplicity, you don’t have to choose.  The Syncplicity SharePoint Connector allows you to seamlessly extend mobile access to your ECM systems like SharePoint and Documentum.  You can also choose to augment those systems with native sync and share functionality provided by the core Syncplicity service.  It’s all part of Syncplicity’s “no silos” approach.

A picture is worth a thousand words:

 

Sharepoint-account-in-device.png

 

See what we did there?  You can extend access to SharePoint to iOS, Android, and Windows Phone users.  There’s a fantastic (but brief) writeup on the functionality here.

Why does EMC World bring a smile to my face?

EMC World – Those words bring a smile to my face.  It gives me, and hundreds of others like me at EMC, the opportunity to meet with customers.   We cherish the opportunity to get out and meet with customers.  I know that I often work on projects for weeks, even months and never get the opportunity to get live feedback from customers.  Sure we get feedback second hand from sales or even technical engineers but there is nothing like the unfiltered feedback directly from a customer.

 

So, it is without hesitation, that I ask that you stop by Booth 850, take a look at the many technical solutions for Microsoft applications we have developed over the past few months and give us your candid feedback!  We welcome it.

 

We have solutions to help you find new power in System Center; we show you how to increase performance of SQL server; we help you regain control of your Exchange environment; we show you can easily manage and control storage infrastructure using the PowerShell toolkit; we show you how to save days deploying SharePoint  and so  many more.

[Howto]Manage Isilon Snapshots with Networker 8.2 in networker2go

This Post contains Screenshots of upcoming networker2go. it is subject to change !

 

First of all, Virtual Geek  posted a nice Update Update on how to get EMC´s Scaleout Fileserver  iSILON as a Virtual Appliance for testing.

http://virtualgeek.typepad.com/virtual_geek/2014/04/love-isilon-want-to-play-merry-xmas.html

Good start for those who want to Test Isilon with Networker Snapshot management for NAS that is currently in Beta!

 

Here is a Brief Walkthrough .

First off all we specify a new Networker Client.

In my Lab, i connect to Isilons Smart Connect Address:

Make sure to check NAS Device

 

 

Next, we have to specify the Credentials for management,

NDMP if we like to do a Rollover to a NDMP Device or Data Domain :-) ,

and the File Server credentials when we like to Mount the Volumes for restores

 

Next we can select the Snapshot Configuration.

In the beta, only Local is available.

We create a new Group with an 2 Hour Schedule starting from 00:00

 

Next i create a new Snapshot policy, 12 Snaps daily, every 2nd backup

 

 

As for now, we leave NDMP to Dump ....

 

 

 

 

 

This si our Summary:

 

 

 

 

When you start the group, you will see the Snapshots automatically Created on the Isilon.

 

You can also Import the Existing Snapshots into NSM:

A run Discovery from Devices in the NMC will discover all Snaps created by SnapIQ:

 

 

Now, for a recover, i can select to recover from the Snapshot or from the NDMP Backup.

In this Example i will retore from a Snapshot and use my Networker Server as Recover target.

 

 

I can now select the Saveset to Recover and the Mount option to Browse the Saveset:

 

The Snapshot get´s mounted:

 

And is Accessible from the Mounthost:

 

I will post a Howto for configuring Isilon into Networker2go soon.