TempDB Growing WAY too big...

[MD]

Project Server 2007 w/ SP2
When building out the OLAP cube, it is building out in excess of 65Gig. I
have several dimensions but nothing out of the ordinary. I have it set to
earliest start and finish as well. The TempDB fills up and pooof!

Any thoughts?

 

[Guest]

see this:
http://blogs.msdn.com/brismith/arch...p-cube-builds-and-large-tempdb-revisited.aspx

 

[MD]

We found that article right after I posted... yes that was the fix... our
build time went from 4 hours and not working at all to 3 minute run...
SWEEEET!