SSAS Articles 
Performance Tuning Check List for Performance Optimisation in SQL Server Analysis Service 2005
Performance Tuning Check List for Performance Optimisation in SQL Server Analysis Service 2005
| Check List for Performance Optimisation in SQL Server Analysis Service 2005 |
| Written by Dinesh Asanka |
| Tuesday, 05 February 2008 05:25 |
|
No matter what your platform or the tools that you are using, performance is almost always the number one feature that customers require. In the case of SQL Server Analysis Service (SSAS), there are four areas where we can improve the performance. They are database design, processing, querying and configuring SSAS. Key Attribute For each dimension, there should be a key attribute. If you have a choice between selecting a key attribute from an integer or varchar you should select an integer column as your key attribute. Allocating an integer column as a key attribute not only improves the query performance but also requires less storage. If you include an integer as the key attribute, then you need to have an integer column for the FACT table to link with dimension table. This will again assist to improve the query performance. |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate
