Friday, March 23, 2012

MovieClick model - memory required

If I add more than 3 nested tables the model appears to hang. Is this due to insufficient memory? How much memory is recomended? When the model build is stopped it appears to lock other models in the project - how can they be unlocked without rebuilding the whole project?

I woul appreciate any help as I am new to Data Mining

Thank you

Hello

The default AS configuration is rather conservative with regard to system resources. You can try changing the default configuration, here is how

Using SQL Server management Studio, connect to Analysis Services 2005, right-click on the server and select Properties, then change the following entries to the indicated values. You might need to switch the property viewer to Advanced mode (there is a check-box labeled 'Advanced properties' in the lower part of the box)

(NOTE: the suggested values below are for a single CPU machine)

EntryDefault valueChange it to:
CoordinatorExecutionMode-4-16
Thread Pool \Process \MaxThreads64128
Thread Pool \Process \Concurrency2-4

The SQL Server Books On-line contain more information on the various configuration parameters for Analysis Services. If these changes are performed before starting the processing, then it is not necessary to restart the service

Please let us know if it worked

|||

Thank you.

The changes are amazing!

No comments:

Post a Comment