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 query times slowed down to several minutes. This slowdown prevented the customer's project from being successfully deployed.
Tags: mdx, performance