Dell PowerEdge External Media System 1434 Configuration

Also see for PowerEdge R720xd: Technical guide Technical guide Technical guide Getting started guide Owner's manual

Contents

Dell PowerEdge External Media System 1434 Configuration Manual pdf 4 page image

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse onPowerEdge R720xd4IntroductionA data warehouse is a large store of data accumulated from a wide range of sources. The stored data isanalyzed for trend analysis, business intelligence reporting, and various types of predictive analysis.With today’s never ending data growth and complexity, it is becoming a tedious job for customers tobalance capacity and performance within the data warehouse system. Growing data volumes andloading challenges, OLAP query complexity, and number of users are causing response times toincrease. IT executives are looking for solutions that offer lower cost, easier management, and betterperformance.There are many challenges in designing a database configuration for OLAP workloads. One is ensuringan optimal balance of I/O, storage, memory and processing power.Dell™ and Microsoft® jointly developed guidelines and design principles to assist customers in designingand implementing a balanced configuration specifically for Microsoft SQL Server® data warehouseworkloads to achieve “out-of-box” scalable performance.This white paper describes the architecture design principles needed to achieve a balancedconfiguration for the Dell PowerEdge™ R720xd server using the Microsoft Fast Track Data Warehouse4.0 guidelines.Microsoft SQL Server Fast Track Data WarehouseIn order to overcome the limitations of traditional data warehouse systems, Microsoft has developed acost-effective solution that optimally balances the hardware and software capabilities of the system. Itprovides an easy to deploy data warehouse infrastructure by mainly focusing on storage tuning anddatabase layout. Fast Track Data Warehouse (FTDW) implements data warehouse solutions differently.As most data warehouse queries scan large volumes of data, FTDW designs are optimized for sequentialscans and reads. These methodologies yield performance much better than that of traditional datawarehousing systems. Based on this, Dell has developed a reference guide that helps customersimplement FTDW on Dell hardware.Dell Fast Track Data Warehouse Reference ArchitectureIn order to optimize data warehouse stack component performance, each layer must be properlytuned. Table 1 lists the Proposed Reference architecture along with the assigned Solution IDs. Thefollowing sections explain the tuning of selected hardware and software.Table 1. Dell Fast Track Reference Architecture Solution DetailsSolution Description Configuration IDDell Fast Track 4.0 Configuration PowerEdgeR720xd 2209618