A Low Cost Data Warehouse Using SQL Server 2008

A Low Cost Data Warehouse Using SQL Server 2008

Cover

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.

Vendor:
Dell and Microsoft SQL
Posted:
08 Oct 2010
Published
29 Jul 2009
Format:
PDF
Length:
24 Page(s)
Type:
White Paper
Language:
English
Already a Bitpipe member? Login here

Download this White Paper!

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy