Dell PowerEdge R720xd User Manual

Page 3 - Contents; Tables

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 3 Contents Introduction ............................................................................................................. 4 Microsoft SQL Server Fast Track Data Warehouse ...........

Page 4 - Dell Fast Track Reference Architecture Solution Details; Solution Description

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 4 Introduction A data warehouse is a large store of data accumulated from a wide range of sources. The stored data is analyzed for trend analysis, business intelligence reporting, and various...

Page 5 - Hardware Component Architecture; Proposed Dell Fast Track Reference Architecture; X 8GB DDR3 DIMMs @1333MHz)

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 5 Hardware Component Architecture Redundant and robust tests have been conducted on Dell’s PowerEdge servers to determine best practices and guidelines for building a balanced FTDW system. Fi...

Page 6 - Dell PowerEdge R720xd Server; Power Edge R720xd Technical Guide; Processors; The; Memory; Second Socket Not Populated

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 6 Dell PowerEdge R720xd Server The Dell PowerEdge R720xd server is a 2-socket, 2U high-capacity, multi-purpose rack server offering an excellent balance of internal storage, redundancy, and v...

Page 7 - Internal Storage Controller (PERC H710P Mini) Settings; Virtual Disk Settings

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 7 Refer to the Microsoft Fast track 4.0 Reference Guide for detailed recommendations on system memory configuration. Internal Storage Controller (PERC H710P Mini) Settings The Dell PERC H710P...

Page 8 - OS

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 8 Figure 4. Internal Storage Controller Settings RAID configuration One of the most critical decisions to make when deploying a new storage solution is which RAID type(s) to use, because that...

Page 9 - Drive Slot configuration:; Mount Point Naming and the Storage Enclosure Mapping; Virtual Disk Label; Log

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 9 Drive Slot configuration:  Slot 0-17: Nine RAID 1 disk groups were created, each configured with a single Virtual Disk dedicated for the primary user data.  Slot 18-21: One RAID 10 disk g...

Page 10 - Storage System Components; Microsoft Fast Track Data Warehouse 4.0 Reference Guide; Application Configuration; Settings used for Windows 2008 R2 SP1 operating system:; Enable Lock Pages In Memory; This Policy setting is enabled to prevent the system from

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 10 Figure 6 represents the storage system configuration for the proposed Fast Track reference. Figure 6. Storage System Components Data file 1 Data file 2 Data file 3 Data file 4 User databas...

Page 11 - SQL Server Configuration; SQL Server Performance Tuning & Trace Flags; SQL Server Maximum Memory; Using the Resource Governor; Max Degree of Parallelism:; Maximum degree of parallelism configuration option; Performance Benchmarking; Baseline Hardware Characterization using Synthetic I/O; Fast

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 11 SQL Server Configuration  The following startup options were added to the SQL Server Startup options: o -E : This parameter increases the number of contiguous extends that are allocated t...

Page 12 - SQLIO Line Rate Test from Cache (Small File); INTERNAL STORAGE

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 12 SQLIO. This test verifies the maximum bandwidth available in the system to ensure no bottlenecks are within the data path. Figure 7. SQLIO Line Rate Test from Cache (Small File) POWER EDGE...

Page 13 - SQLIO Real Rate Test from Disk (Large File); Fast Track Database Validation; Calculating MCR

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 13 Figure 8. SQLIO Real Rate Test from Disk (Large File) POWER EDGE R720-XD PERC H700 Controller INTERNAL STORAGE RAID 1 Windows Server 2008 R2 SP1 SQL Server 2012 Intel E5-2643 4 core CPU Si...

Page 14 - Performance Metrics; Metric; Maximum observed IO rate.

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 14 For the validated Fast Track configuration, the aggregate BCR was 950.75 MB/s. During the evaluation cycle, the system configuration was analyzed for multiple query variants (simple, avera...

Page 15 - Conclusion; Avoidance of over-provisioning of hardware resources.

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 15 Conclusion The Dell Microsoft Fast Track Data Warehouse architecture provides a uniquely well-balanced data warehouse implementation solution. By following the best practices at all the la...

Page 16 - References; An Introduction to Fast Track Data Warehouse Architectures

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd 16 References Dell SQL Server 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 Micr...