Report Portal

SSAS: Are my Aggregations processed?

You have designed Aggregations for your cube, but how do you know that they are currently processed?

Hopefully you have your processing routines setup in production so that your indexes are always kept processed. But maybe you are working in a development environment or you are performance tuning that you want to double check that your aggregations are currently processed.

It is not immediately obvious how you can figure if the indexes for a partition or a set of partitions are processed as this information is not exposed in SSMS anywhere.

One way in which you can find it out with an XMLA discover call to the DISCOVER_PARTITION_STAT rowset, but that returns the results in big lump of XML which is not as easy to read as a tabular result set.

Read more...

Tags: amo, script, powershell

 

2007-2015 VidasSoft Systems Inc.