Speed Up Cube Processing

You can accelerate SQL Server Analysis Services cube processing by adjusting two setting, without changing data architecture or other costly approaches.

1. Use Shared Memory protocol to optimize source data retrieval >1.5 times

It’s applicable when your data warehouse database is on the same machine as Analysis Services, which is almost always the case. (There are definite reasons for adhering to this architecture: this keeps production cube intact during processing; cube refreshing is done afterwards by synchronizing or backing-and-restoring.)

Go to Sql Server Configuration Manager à SQL Server Network Configuration

à Protocol For MSSQLSERVER à Shared Memory protocol is enabled

Force shared memory use. Change data source connection string in OLAP data source properties: add lpc:. The connection string will look like this: Data Source=lpc:; Integrated Security=SSPI; Initial Catalog=

2.Disable Flight Recorder on machine which does data processing

Go to Analaysis Service properties à click on general tab à Set Log\Flight Recorder\Enabled property to false. (By default, it is set to true.)