SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

The Analysis Services 2008 Performance Guide

SQL Server Techical Article

Published: October 2008
Writer: Richrd Tkachuk and Thomas Kejser
Technical Reviewers: T.K. Anand, Marius Dumitru, Greg Galloway, Siva Harinath, Denny Lee, Edward Melomed, Akshai Mirchandani, Mosha Pasumansky, Carl Rabeler, Elizabeth Vitt, Sedat Yogurtcuoglu, Anne Zorner

This white paper describes how application developers can apply query and processing performance-tuning techniques to their SQL Server 2008 Analysis Services OLAP solutions.

For more information, please refer to the Analysis Services 2008 Performance Guide whitepaper.

Comments

 

Andrew Karcher's Bits o' Data said:

So I see all these great posts during the week and I think, “I wonder if everyone else is seeing this

February 15, 2009 3:18 PM
 

Tour Guide at the Khajuraho temples India 2007 said:

Pingback from  Tour Guide at the Khajuraho temples India 2007

February 16, 2009 12:43 PM
 

SQL Server 2008 White Paper: Analysis Services Performance Guide | Kasper de Jonge BI Blog said:

Pingback from  SQL Server 2008 White Paper: Analysis Services Performance Guide | Kasper de Jonge BI Blog

February 19, 2009 7:35 AM
 

Technical Notes said:

Author: Carl Rabeler Contributor: Josh Caplan Reviewers: Prem Mehra, Denny Lee, John Desch, Wayne Robertson

February 8, 2010 9:02 PM
 

Jensch said:

I have recently downloaded the SSAS Performance Guide 2008 from microsoft.com.

As I started reading the document, and trying to get deeper into things, I however found that some of the links were dead.

The reason for this is, that all (correct me if I'm wrong) self-referencing links (links to anchors in the same document) is refering to a document on a local machine with the given path of: C:\Users\Beth\Documents\Vend\Docs\SQL White papers\SSASPerfGuide2008_v1_(2).docx

The issue is not critical, but I thought I'd let you know.

February 10, 2010 3:10 PM
 

Whitepapers said:

SQL Server Technical Article Authors : Denny Lee, Kay Unkroth Contributor : James Podgorski Technical

June 9, 2010 1:47 PM
 

RobertLDavis said:

Quick question. The whitepaper recommends using a network packet size of 32K, but the figure shows a packet size of 32767 which would be 1 byte less than 32K. Is there a particular reason to use 32767 instead of 32768?

I ask because our engineering team wants to use a packet size of 32240. When I asked why they want to use a non-even packet size, they referenced a different whitepaper that recommends a packet size of 32K but then shows 32240 in the picture. I suggested they use this whitepaper instead for reference, but I am curious about thy the demonstrated value isn't exactly 32K.

July 14, 2010 1:32 PM
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
Copyright 2008 Microsoft Corporation. All Rights Reserved.