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

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.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

A

archyman2015-02-22 01:23:46

Topic of undergraduate work Business Intelligence? 0Reply

A

Anton2015-03-16 19:15:59

What literature can you recommend? Subject "Data Warehouse", "OLAP/OLTP technologies"? 0Reply

V

Val2015-04-01 15:50:31

What is the fundamental difference between analytics in Kibana and OLAP cubes? 2Reply

S

Sergey Fuksman2015-04-08 16:07:22

Who has experience implementing Pentaho Community? 1Reply

N

Nikita Zvonarev2015-08-28 12:08:40

MSSQL, OLAP, MDX, DMX: how to organize? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question