White Papers
Project REAL: Enterprise Class Hardware Tuning for Microsoft Analysis Services
Overview This paper describes best practices for hardware optimization for a multi-terabyte SQL Server 2005 data warehouse and cube. It describes hardware testing and tuning exercises conducted with large-scale Analysis Services (MS OLAP) cubes based on a multi-terabyte SQL Server data warehouse. Topics include lab setup; cube processing, MDX query load testing, processor comparison, and storage optimization as they pertain to an enterprise implementation of Analysis Services. The test exercise walks through a hardware tuning plan which reduced cube processing by half. It shows the significance of disk I/O, number of processors, and processor architecture on cube processing and concurrent user load testing performance.
| Publisher | Microsoft | File Format | WORD |
|---|---|---|---|
| Date Published | September 2006 | ||
| Format | White Papers | ||
| Topics |
|
||
-
Did you find this white paper useful?
White Paper RSS
Download
Register
