CJ

The circle of life – ** .Net – Training – MOSS **

  • Past Post

  • Vistor Locations

Sql Server Analysis Services 2005 Performance Guide

Posted by Clayton James on February 11, 2007

Microsoft has recently released their SSAS 2005 performance guide

Major topics from the contents page include:

  • Enhancing Query Performance
    • Understanding the querying architecture
    • Optimizing the dimension design
    • Maximizing the value of aggregations
    • Using partitions to enhance query performance
    • Writing efficient MDX
  • Tuning Processing Performance
    • Understanding the processing architecture
    • Refreshing dimensions efficiently
    • Refreshing partitions efficiently
  • Optimizing Special Design Scenarios
    • Special aggregate functions
    • Parent-child hierarchies
    • Complex dimension relationships
    • Near real-time data refreshes
  • Tuning Server Resources
    • Understanding how Analysis Services uses memory
    • Optimizing memory usage
    • Understanding how Analysis Services uses CPU resources
    • Optimizing CPU usage
    • Understanding how Analysis Services uses disk resources
    • Optimizing disk usage
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: