Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 1
Contents
Introduction ................................................................................................................ 3
Audience and Scope .................................................................................................... 3
Microsoft SQL Server Fast Track Data Warehouse ................................................................... 3
Dell Fast Track Data Warehouse Reference Architecture .......................................................... 4
Hardware Component Architecture ................................................................................. 4
Dell PowerEdge R510 Server ....................................................................................... 5
Processors ............................................................................................................. 5
Memory ................................................................................................................ 5
Internal Storage Controller (PERC H700) Settings ................................................................ 5
Stripe element size .................................................................................................. 6
Read policy ............................................................................................................ 6
RAID configuration ................................................................................................... 7
Application Configuration ............................................................................................. 7
Windows Server 2008 R2 SP1 ....................................................................................... 7
SQL Server Configuration ........................................................................................... 8
Internal Storage System ............................................................................................ 8
Performance Benchmarking ............................................................................................. 9
Baseline Hardware Characterization using Synthetic I/O ....................................................... 9
Fast Track Workload Evaluation ................................................................................... 11
Calculating MCR .................................................................................................... 11
Calculating BCR .................................................................................................... 12
Populating Your Data Warehouse .................................................................................. 12
Building an Integration Process .................................................................................... 13
Configuring Integration Automation ............................................................................ 16
Deploy an Integration Process ...................................................................................... 17
Addressing Enterprise-Class Integration ....................................................................... 18
Reviewing Overall Integration Performance .................................................................. 18
Reviewing Individual Process Executions ...................................................................... 18
Exploring Atoms .................................................................................................... 19
Subscribing to Process Alerts .................................................................................... 19
Conclusion ................................................................................................................ 20
References ................................................................................................................ 21
Appendix .................................................................................................................. 22
