A Low Cost Data Warehouse Using SQL Server 2008

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.

Dell and Microsoft SQL
08 Oct 2010
29 Jul 2009
24 Page(s)
White Paper
Already a Bitpipe member? Login here

Download this White Paper!

By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.