Optimize tempdb usage on cube build

[EarthDog]

Hi All!

I was having issues with my SQL Server disk space. I thought initially that the issue was coming from my SSIS tasks but that was not the case.

I am seeing my tempdb data file go up to 36GB when i build my cubes.

How can i start investigating how to reduce this usage? When the space spikes i am monitoring the temp db usage and i see that there are huge sql scripts that make multiple selects from sub queries

select .... from (select ...)

My transformer models are based almost entirely on Framework Models.

Any ideas / resources?

Thanks