SSAS small/big query interaction

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 against their 110 GB cube took about 3 minutes.  When running both together, small… Read more

SSAS Partition Slicing

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 “slices” to examine partitions at query time.  The slices are stored as… Read more