Dell Quickstart Data Warehouse Appliance Quick Reference Guide
Dell
Quickstart Data Warehouse
Appliance 1000
Reference Architecture
Dell Quickstart Data Warehouse Appliance 1000
THIS DESIGN GUIDE IS FOR INFORMATIONAL PURPOSES ONLY, AND MAY CONTAIN TYPOGRAPHICAL
ERRORS AND TECHNICAL INACCURACIES. THE CONTENT IS PROVIDED AS IS, WITHOUT EXPRESS OR
IMPLIED WARRANTIES OF ANY KIND.
© 2012 Dell Inc. All rights reserved. Reproduction of this material in any manner whatsoever without
the express written permission of Dell Inc. is strictly forbidden. For more information, contact Dell.
Dell, the DELL logo, the DELL badge, and PowerEdge are trademarks of Dell Inc. Microsoft, Windows
Server, and SQL Server are either trademarks or registered trademarks of Microsoft Corporation in the
United States and/or other countries. Intel and Xeon are either trademarks or registered trademarks of
Intel Corporation in the United States and/or other countries. Other trademarks and trade names may
be used in this document to refer to either the entities claiming the marks and names or their
products. Dell Inc. disclaims any proprietary interest in trademarks and trade names other than its
own.
June 2012
Page ii
Dell Quickstart Data Warehouse Appliance 1000
Contents
Introduction ............................................................................................................ 2
Audience ............................................................................................................. 2
Reference Architecture ............................................................................................... 2
Hardware Component Architecture .............................................................................. 2
Quickstart Software ................................................................................................... 4
Applications Settings .................................................................................................. 4
Windows Server 2008 R2 SP ..................................................................................... 4
SQL Server 2012 .................................................................................................. 4
Internal Storage Controller (PERC H710P Mini) ............................................................... 5
RAID Disk Group .................................................................................................. 7
Internal Storage System ......................................................................................... 7
Conclusion .............................................................................................................. 9
References ............................................................................................................. 10
Tables
Table 1: Dell Quickstart Reference Architecture Component Details .......................................... 2
Table 2: Mount Point and Storage Enclosure Mapping ............................................................ 8
Table 3: Performance Metrics........................................................................................ 9
Figures
Figure 1.
Figure 2.
Figure 3.
Figure 4.
Page 1
Memory Slot Locations ................................................................................. 4
Virtual Disk Settings ................................................ Error! Bookmark not defined.
Internal Storage Controller Settings .............................. Error! Bookmark not defined.
RAID Disk Group Configuration .................................... Error! Bookmark not defined.
Dell Quickstart Data Warehouse Appliance 1000
CPU (1) Intel Xeon E5
-
2643 CPU
@3.3GHz
(H
yper-T
hreading Technology
Enabled)
Sockets
1
CPU Cores
4
96GB RAM
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-ofbox” 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
Memory
Page 2
• (4) 16GB DDR3 DIMM @1333MHz
• (4) 8GB DDR3 DIMM @1333MHz
Loading...