Z
Z
zhaar2019-04-02 11:46:56
OLAP
zhaar, 2019-04-02 11:46:56

MS Analysis periodically rebuilds indexes. How to track / control?

Periodically, when recalculating an analytics cube, Microsoft Analysis Service rebuilds the indexes, which shifts the cube calculation time by an hour or two compared to the usual preparation time.
Is it possible to somehow track the prerequisites for the recalculation of indices, or track the very fact of launching such a recalculation? Keeping the trace permanently in SQL Profiler is not suitable.

Answer the question

In order to leave comments, you need to log in

Similar questions

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question