Add Refresh Metrics to Performance Analyzer
It would be extremely useful if the new Performance Analyzer recorded metrics about what is going on during a report Refresh. We could really use some insight on what's happening during:
- 'Creating connection in model...'
- 'Waiting for other queries...'
- 'Loading data to model...'
How long are queries taking to Evaluate or Load? What 'other queries' are you waiting on? Why is Evaluating taking so long?
Refresh performance is by far our biggest bottleneck and it's very difficult to analyze so this would be a very welcome addition.
Jeffrey J Killeen commented
Also what is actually happening during each of these phases
David Kennedy commented
Please add these features.
Guy Jara commented
Agreed. Great idea!