Archive for the ‘Network’ Category

How to Process a SSAS MOLAP cube as fast as possible – Part 2 (2014-3-9)

Special thanks to Dirk Gubbels for his contribution on the data type optimization part and review!(Follow Dirk on Twitter: @QualityQueries). In part 1 we looked at a method to quantify the work that gets done by SQL Server Analysis Server and found that the OLE DB provider with a network packet size of 32767 brings […]

How to Process a SSAS MOLAP cube as fast as possible – Part 1 (2014-2-9)

Recently, with some colleagues, I was working on a project with a serious challenge; there was this Analysis Server 2012 system with 40 physical cores, half a Terabyte of RAM and 10TB of SSD storage waiting to get pushed to its limits but it was installed via the famous ‘next,next finish’ setup approach and we […]