This sounds more like workbook issues than Server. Performance recordings can help with determining where the slowdowns are. Extracts or live data connections? Hidden fields enabled?
However, does the Server have adequate resources and build setup for the tasks? # of cores, RAM, Online or VM or physical system? etc. There are so many factors involved.
I believe they have a combination of extracts and live connections. I don't believe they are hiding any fields. In terms of server resources, we just went through an upgrade and for "normal" use we should be more than adequate from that perspective. I just wasn't sure if it's typical to have 80 unique data sources published, or having workbooks over 1 GB in file size.
Do you know if having a high # of user filters would impact performance?
2 of 2 people found this helpful
"Typical" and "normal" are subjective so I can't say definitively. We have 87 published data source out of 928 total data sources. I consider us a high-extract environment because pretty much everyone uses an extract to minimize db impact and improve report performance. As you can see, our largest extract is 4GB but only takes 4 seconds to render:
Our environment is 8 cores with 4 backgrounders -- and they are freakin' busy little bees!
Yes, filters can affect performance. Exactly how is not my expertise so I'll let someone more knowledgeable explain that. Check this out: https://alanattableau.files.wordpress.com/2015/07/designing-efficient-workbooks-v92.pdf
I would agree I'm being vague by using terms like normal or typical....but looking at your reports (87 published data sources, workbooks over 1 GB in size) it appears my co-workers business unit isn't an outlier with the size and quantity of reports/published data sources.
While I don't know the particulars for our server environment, I believe we are around the same size....so it's troublesome to hear you can open your large report and it takes seconds to render. So that sounds like it is workbook driven. I'm continuing working with her and will come at it from that focus. Thanks for your input.
Jason, if you remember (I know we're all jumping from fire to fire) it would be nice to know the result of your effort, if the issue was due to the workbook or Server or both. It would either validate what is already known or teach us something new