A Low Cost Data Warehouse Using SQL Server 2008
From a performance point of view, organizations prefer to have separate decision support systems (DSS) and Online Transaction Processing (OLTP) environments. Separating the DSS environment from the OLTP environment helps customers to manage these systems efficiently and this helps to perform better capacity planning.
This paper outlines different considerations for separating DSS from OLTP environments and touches upon technical procedures for achieving the same. A low cost data warehouse solution which comprises Dell PowerEdge T710, Dell PowerVault MD1120 and PERC6/E RAID controller is proposed. This paper highlights the capability of Dell PowerVault MD1120 to handle the data warehouse workloads. This paper also analyses different storage topologies and discusses some of the storage interface optimizations based on a standard DSS workload.