sponsored by Dell and Microsoft SQL
Posted:  08 Oct 2010
Published:  29 Jul 2009
Format:  PDF
Length:  24  Page(s)
Type:  White Paper
Language:  English

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.

Data Warehouse Architectures | Data Warehouse Software | Data Warehouses | Database Management | Decision Support Systems | OLTP | SQL Server

View All Resources sponsored by Dell and Microsoft SQL

About TechTarget:

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines

All Rights Reserved, Copyright 2000 - 2014, TechTarget | Read our Privacy Statement