Related Items
  FREE Insurancenetworking.com Site Registration!
Sign up today and access the leading source of Insurance I.T. information on the Web.

Your FREE site registration entitles you to

FREE Insurance Networking eNewsletters

Search more than 7 years worth of archived data

White Papers and Industry Research that provide valuable insights on a variety of technologies and implementation issues

Access our Web Seminar series

   

Enterprise Class Hardware Tuning for Microsoft Analysis Services

Price: Free
Report Format:
Posted: November 17, 2007

Register to Download

This paper describes best practices for hardware optimization for 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 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 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.


Register to Download

Spotlights