Tuesday, December 2, 2008

SQL Server Analysis Services 2008 Performance Tuning Whitepaper

This paper was recently released by Microsoft. It covers all of the things you need to look for when tuning SSAS 2008 (and is very relevant to 2005 as well). From the download description:

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.
Enhancing Query Performance - Query performance directly impacts the quality of the end user experience. As such, it is the primary benchmark used to evaluate the success of an online analytical processing (OLAP) implementation. Analysis Services provides a variety of mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval. In addition, you can improve query performance by optimizing the design of your dimension attributes, cubes, and Multidimensional Expressions (MDX) queries.
Enhancing Processing Performance - Processing is the operation that refreshes data in an Analysis Services database. The faster the processing performance, the sooner users can access refreshed data. Analysis Services provides a variety of mechanisms that you can use to influence processing performance, including efficient dimension design, effective aggregations, partitions, and an economical processing strategy (for example, incremental vs. full refresh vs. proactive caching).
Tuning Server Resources – There are several engine settings that can be tuned that affect both querying and processing performance.

 

Download the paper here: http://www.microsoft.com/downloads/details.aspx?FamilyID=3be0488d-e7aa-4078-a050-ae39912d2e43&DisplayLang=en

2 comments:

smith said...

Hi Ted,

I am Amelia, the webmaster of BikerKiss.com. While reviewing blog sites, I came across yours, and deeply impressed by the quality of your blog. You might be interested in my offer. We would like to work with you setting up Dating Site for Biker Friends.

We can set it up for you at no cost if you have strong interest in work-at-home business. You can pick the name for the biker dating site, and own the domain and brand. We take care of all the backend and engineering work.

You don't have to worry that no one exists at your biker dating site at the beginning. Your site will share millions of qualityprofiles with other biker sites we have already set up. Your users can immediately contact hundreds of thousands of other users once they register at your biker dating site.

You will pay you $2 for each profile or $30 for each sales you drive to us.

If you are interested, please let me know at bikerwebmaster@gmail.com.

Amelia
http://af.bikerkiss.com

Steve J. Laye said...

Great article to increase the query and processing performance. Symtex are an expert database consultancy and development provider. We live, breath and eat Microsoft SQL Server and .Net programming day and night; really we love it and it's that passion which keeps us at the top.