Dell PowerEdge External Media System 1634 Configuration - Page 3
Browse online or download pdf Configuration for Server Dell PowerEdge External Media System 1634. Dell PowerEdge External Media System 1634 16 pages. Statement of volatility
Also for Dell PowerEdge External Media System 1634: Getting Started Manual (12 pages), Manual (38 pages), Manual (29 pages), Using Manual (16 pages), Manual (10 pages)
Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on
PowerEdge R720xd
Contents
Introduction ............................................................................................................. 4
Microsoft SQL Server Fast Track Data Warehouse ................................................................ 4
Dell Fast Track Data Warehouse Reference Architecture ....................................................... 4
Hardware Component Architecture .............................................................................. 5
Internal Storage Controller (PERC H710P Mini) Settings ...................................................... 7
Application Configuration ........................................................................................ 10
Performance Benchmarking ......................................................................................... 11
Baseline Hardware Characterization using Synthetic I/O ................................................... 11
Fast Track Database Validation ................................................................................. 13
Fast Track Database Validation with Column Store Index (CSI) ........................................... 14
Reference Architecture Performance Details ................................................................. 14
Conclusion ............................................................................................................. 15
References ............................................................................................................. 16
Tables
Dell Fast Track Reference Architecture Solution Details ........................................... 4
Tested Dell Fast Track Reference Architecture Component Details .............................. 5
Mount Point Naming and the Storage Enclosure Mapping ........................................... 9
Performance Metrics ..................................................................................... 14
Figures
Proposed Dell Fast Track Reference Architecture.................................................... 5
Memory Slot Locations .................................................................................... 6
Virtual Disk Settings ....................................................................................... 7
Internal Storage Controller Settings .................................................................... 8
RAID Configuration ......................................................................................... 8
Storage System Components ........................................................................... 10
SQLIO Line Rate Test from Cache (Small File) ...................................................... 12
SQLIO Real Rate Test from Disk (Large File) ........................................................ 13
3