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)
Entry | Default value | Change it to: |
CoordinatorExecutionMode | -4 | -16 |
Thread Pool \Process \MaxThreads | 64 | 128 |
Thread Pool \Process \Concurrency | 2 | -4 |
Please let us know if it worked
|||
Thank you.
The changes are amazing!
No comments:
Post a Comment