Know and manage the data process flow for performance

[Schillo87]

Hello everyone!

I have this environment:

• SQL Server 2017 (latest patch) with data
• SSAS with Import Model
• Power BI Report Server in Connect Live Mode with SSAS Model

I would like to know how this entire environment works with memory usage, like RAM and DISK.... Is there a data process flow that explains how the data navigates from the database to the final report?

I want to prevent any performance issue or server crashes. How can I read some info about it? Just an example:

If I have a tabel with 800k records... how does it translate into ram and disk consumption?

What I have to configure? Server RAM? Client RAM? SSAS RAM Configuration?

Many thanks!

Riccardo