Report Portal
Report Portal
Home | Profile | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server General Issues
 SQL Server Analysis Services (SSAS)
 How to Process SSAS OLAP cubes as fast as possible
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  


588 Posts

Posted - 02/20/2014 :  09:31:53  Show Profile  Reply with Quote
How to Process a SSAS MOLAP cube as fast as possible – Part 1

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 had to tune the box from scratch. Also we had to pull the data from a database running on another box which means the data processing will be impacted by the network round-tripping overhead.

Raed more:
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Report Portal © RP Go To Top Of Page