| Publisher | Microsoft | ||
|---|---|---|---|
| Format | 640.0KB WORD | Date added | 01 Sep 2006 |
| Topics | Application Servers, Database Management, Business Intelligence - Data Warehousing | ||
| Downloads | 109 | ||
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.
Did you find this white paper useful?
23 out of 50 users found this white paper useful
Related white papers
Citrix Business Solutions: Powered by Datacore Software
DataCore Software provides storage virtualisation solutions that make storage and SAN infrastructures efficient, fault tolerant, flexible and virtual. DataCore Storage Virtualisation is the foundation for the Total Enterprise Virtualisation -...
PlateSpin Pledges Extended Support for Citrix XenSever Customers
PlateSpin ULC, a Novell company, today reaffirmed its commitment to support Citrix XenServer across the PlateSpin product line. XenServer support is a key element of PlateSpin's multiplatform strategy, which aims...
Unlock the Power of Server Virtualisation
Citrix XenServer is the simplest and most efficient way to virtualize and provision servers to deliver a dynamic datacenter - a flexible aggregated pool of computing and storage resources. Citrix...
TechNet Webcast: Windows Server 2008 R2 AD RMS and FCI Better Together (Level 300)
Windows Server 2008 R2 and the new wave of 2010 server products introduce powerful new usage scenarios, features, and tools for AD Rights Management Services (RMS). In this webcast, the...
College Eases Process Development, Creates a "Culture Shift" in Process Improvement
In order to boost the effectiveness of students, faculty, and staff throughout the institution, Florida State College at Jacksonville wanted to improve how it creates the IT solutions that support...
HP Business Service Management software resolves ITSM problems at Virgin Atlantic
Objective: Virgin Atlantic Airways wanted to select and deploy an integrated monitoring toolset to raise end-user satisfaction, reduce service disruption, increase application performance and enhance the visibility of infrastructure problems. Approach: Deployed an...
MSDN Webcast: Project 2010 and Project Server 2010 Programmability (Level 200)
In this webcast, the presenter provides an overview of the programmability enhancements that are in the upcoming versions of Microsoft Office Project 2010 and Microsoft Office Project Server 2010. The...
