Report Portal

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.

Read more...

Tags: mdx, performance

 

2007-2015 VidasSoft Systems Inc.