Workload and application-centric IT infrastructures have historically been engineered for large enterprises and do not adequately address the needs of a quickly growing remote/branch office (ROBO) or those of your small-to-medium business (SMB) customers. So with customer-inspired design to address their pervasive and unique IT issues, Dell recently introduced PowerEdge VRTX, the first shared infrastructure IT solution optimized for remote and small office environments. PowerEdge VRTX allows you to offer your customers enterprise-class capabilities in a desk-side, space-saving design for greater simplicity, improved efficiency and greater value.

An enterprise class database engine, Microsoft SQL Server supports various online transaction processing (OLTP) and online analytical processing (OLAP) workloads. It is designed for organizations looking to efficiently protect, unlock, and scale the power of their data. SQL Server 2012 is the latest release of Microsoft’s database management platform with new features to enhance performance, security, and management.

Dell offers many great platforms and reference architectures for SQL Server database use cases; however, PowerEdge VRTX, as a virtualized platform, provides an excellent platform to host different types of applications specific to ROBO and small business environments. Setting up a highly-available Microsoft SQL Server 2012 environment on the PowerEdge VRTX is a straightforward process and helps you to keep your customers up and running.

 

Download the assets below for additional information and for a technical deep dive:

Microsoft SQL Server 2012 Solutions for OLTP Applications on Dell PowerEdge VRTX
About: This reference architecture whitepaper discusses the usage of PowerEdge VRTX as the backbone for the enterprise class cloud-ready database platform, Microsoft SQL server 2012. The major use case scenarios discussed are for ROBO and small business deployments. Microsoft Data Protection Manager (DPM) is also discussed in detail as part of a robust data protection mechanism for database deployments on PowerEdge VRTX.

Deployment guide: Configuring a highly-available Microsoft® SQL Server® 2012 environment on a Dell™ PowerEDge ™ VRTX
About: In this guide, we take you through the simple, straightforward process of setting up a highly available Microsoft SQL Server 2012 environment through the AlwaysOn Availability Groups feature on PowerEdge VRTX. Having set up this environment in our labs, we are able to provide you with step-by-step guidelines as well as best practices.

 

Other related publications:

Overview of AlwaysOn Availability Groups (SQL Server)

Design for a Clustered Service or Application in a Multi-Site Failover Cluster

Spotlight on SQL Server

Systems Center 2012 Data Protection Manager

 

Questions? No technical question is too technical! Start the discussion and we’ll make sure to ask our experts.

This blog is the 2nd of the 6 part Blog Series: PowerEdge VRTX and Reference Architectures. Check the other Blogs and Reference Architectures