Quick Reference Guide

Dell Quickstart Data Warehouse Appliance 1000

Page 2

Introduction

Data warehouses store large amounts of data accumulated from a wide range of sources. This data is

generally used for trend analysis, business intelligence reporting, and various types of predictive

analysis.

Because data continuously grows in both volume and complexity, organizations often struggle to

balance data warehouse capacity and performance. Additionally, data integration and cleansing can be

challenging, especially when data originates from multiple sources.

The Dell Quickstart Data Warehouse Appliance is an all-inclusive device that combines a Dell

PowerEdge™ R720xd server with Dell Boomi software and additional services and support. Its balanced

configuration is based on the Microsoft® Fast Track Data Warehouse for SQL Server® 2012 reference

model, which is optimized specifically for SQL Server data warehouse workloads to achieve “out-of-

box” scalable performance.

Audience

This document is intended for customers, partners, solution architects, database administrators,

storage administrators, and business intelligence users who are evaluating, planning, and deploying the

Dell Quickstart Data Warehouse Appliance.

Reference Architecture

The Dell Quickstart Data Warehouse Appliance is an integrated solution built on the Dell PowerEdge

12th generation server platform. The solution is optimized to deliver outstanding data warehouse

performance. This hardware configuration was tested using Microsoft Fast Track Data Warehouse for

SQL Server 2012 Guidelines. The software layer contains SQL Server 2012 running on Microsoft Windows

Server® 2008 R2 SP1 and Dell Boomi data integration software.

Hardware Component Architecture

Dell conducted tests to determine best practices for building a balanced Fast Track Data Warehouse

system on Dell hardware. Based on these results, the Quickstart Data Warehouse Appliance includes the

hardware and software components listed in Table 1.

Table 1: Dell Quickstart Reference Architecture Component Details

Component Details

CPU

(1)

Intel Xeon E5

2643 CPU

@3.3GHz

yper

hreading Technology

Enabled)

Sockets

CPU Cores

Memory

96GB RAM

• (4) 16GB DDR3 DIMM @1333MHz

• (4) 8GB DDR3 DIMM @1333MHz