Browse by Tags
All Tags »
Performance and... »
analysis services (RSS)
Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance
Read More...
As noted within the Analysis Services 2005 Performance Guide , there are some niche situations where setting the Processing Group property to ByTable provides more optimal processing than the default value of ByAttribute. In a customer scenario, we had
Read More...
Default SSAS behavior can sometimes result in small queries being slowed down by concurrently running big queries. Recently in working with a customer, we observed the most common queries when run by themselves took about 1 second and some ad-hoc queries
Read More...
If a report does not use formatted cell values, query time can be reduced. An example is a Reporting Services report that does its own formatting and therefore would not use the formatted values from SSAS. By returning only the value of the cell and not
Read More...
Scale-Out Querying with Analysis Services Using SAN Snapshots
Read More...
Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services There are a variety of things that you can do to improve the performance of an individual MDX query. To begin, you must identify the source(s) of the performance
Read More...
Goal This document describes how to build Create Cache commands. Create Cache for Analysis Services (AS) was introduced in SP2 of SQL Server 2005. It can be used to make one or more queries run faster by populating the OLAP storage engine cache first.
Read More...
Summary: SSAS uses partitions to contain cube data. Small cubes might use only one, but for non trivial cubes, cube designers will create partitions based on ease of managing data and to split groups of data. This document discusses how the server uses
Read More...
Overview SQL Server’s 2005 Analysis Services has introduced several changes to the MDX queries syntax that can lead to better performance than the equivalent AS 2000 queries. Here is a list of tips and tricks as well as best practices on how to get better
Read More...
