June 18, 2024 at 4:21 pm
I don't know what settings would help, but have you looked at the aggregation design recently? If many users are running the same reports regularly it may be possible to create aggregations to support them. It might be worth trying the usage based optimization wizard.
June 18, 2024 at 8:19 pm
We have about 1k calculated measures. Which means tons of aggregations. I'll do some research on usage based optimization wizards. Thank you Ed!
June 19, 2024 at 10:48 am
I wouldn't change any configuration properties unless I have a better understanding of the root cause. If the CPU is high, then it is likely due to either a refresh or a bad query.
I would recommend that you enable the Query Log or use extended events to get an idea of what is running at the time you are experiencing the resource issues. Identify the root cause(s) of the resource utilization spike first, and then act accordingly.
June 19, 2024 at 11:46 am
Thank you for the advice Martin! We will do that.
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply