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 Quickstart Data Warehouse Appliance 1000 Contents Introduction ............................................................................................................ 2 Audience ............................................................................................................. 2 Reference Architecture ............................................................................................... 2 Hardware Component Architecture ..........................................................
Dell Quickstart Data Warehouse Appliance 1000 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.
Dell Quickstart Data Warehouse Appliance 1000 Internal Hard Drives Internal Storage Controller Operating System • • • (22) 300GB 10K 2.5” SAS (18 Data, 4 Logs) (2) 600GB 10K 2.5” SAS (2 Hot Spares) (2) 600GB 10K 2.
Dell Quickstart Data Warehouse Appliance 1000 Figure 1: Memory Slot Locations Second Socket Not Populated See the Fast Track Reference Guide for detailed recommendations on system memory configurations. Quickstart Software In collaboration with Microsoft, Dell developed a wizard to simplify deploying the Quickstart appliance.
Dell Quickstart Data Warehouse Appliance 1000 -E: This parameter increases the number of contiguous extends that are allocated to a database table in each file as it grows to improve sequential access. o -T1117: This trace flag ensures the even growth of all files in a file group when auto growth is enabled. It should be noted that the Fast Track Reference Guidelines recommend pre-allocating data file space rather than allowing auto grow.
Dell Quickstart Data Warehouse Appliance 1000 Figure 2: Virtual Disk Settings Page 6
Dell Quickstart Data Warehouse Appliance 1000 Figure 3: Internal Storage Controller Settings RAID Disk Group One of the most critical decisions when deploying a new storage solution is which RAID type(s) to use, as that choice heavily impacts application performance. Dell tested nine RAID 1 disk groups for database data files and one RAID 10 disk group for log files.
Dell Quickstart Data Warehouse Appliance 1000 For each internal storage array: • Nine RAID 1 disk groups were created, with each consisting of two disks. These RAID groups were dedicated for the primary user data. One RAID 10 disk group was created with four disks. This RAID group was dedicated to host database transaction log files. One RAID 1 disk group was created with two disks dedicated to the appliance operating system. Two disks were assigned as the global hot spares.
Dell Quickstart Data Warehouse Appliance 1000 Conclusion Microsoft Fast Track Reference Guidelines helped achieve an optimized database architecture on the Quickstart Appliance with balanced CPU and storage bandwidth. Table 3 shows performance metrics of the reference configuration. Table 3: Performance Metrics Category Value Description FTDW Rated Data Warehouse Capacity 5 TB This capacity rating is based on “up-to” capacity, but adjusted to account for Fast Track Rated I/O. FTDW Rated I/O 950.
Dell Quickstart Data Warehouse Appliance 1000 References Dell | Microsoft SQL Server 2012 Solutions www.dell.com/sql Dell Services www.dell.com/services Dell Support www.dell.com/support OLTP and OLAP http://datawarehouse4u.info/OLTP-vs-OLAP.html Microsoft Fast Track Data Warehouse and Configuration Guide Information www.microsoft.com/fasttrack http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91448AB733B1AF/Fast_Track_Configuration_Guide.