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)

Entry	Default value	Change it to:
CoordinatorExecutionMode	-4	-16
Thread Pool \Process \MaxThreads	64	128
Thread Pool \Process \Concurrency	2	-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!

Move SQL Server EE databases to SQL Server Std.

I would like to know if we have sql server 2000 EE on build 818, can we
simply restore the master database and other databases to a sql server 2000
standard build 818 without issue?I doubt you can do this with the master database but the others should be
fine.
Mike Kruchten
"ECS" <xxxx@.xx.com> wrote in message
news:OjaxVZdEEHA.2660@.TK2MSFTNGP12.phx.gbl...
> I would like to know if we have sql server 2000 EE on build 818, can we
> simply restore the master database and other databases to a sql server
2000
> standard build 818 without issue?
>|||Anyone else like to comment. If this can not be done what would be the best
and easiest way to move
like 50 databases off of EE onto a standard version of MS SQL?|||Like I said you should be fine for everything except the master, and you
could try that one and see. I'm assuming you have a different machine with
Std. installed that you can test on. The only thing you really need from
master is the login info, which is easy enough to recreate.
I know the other databases work as I use this process on a weekly basis for
a test environment. I'm guessing that if you try it with master the restore
process will complain but I'm only guessing, try it and see. I know it will
complain if you try to restore a backup of master with a different service
pack level.
Mike Kruchten
"ECS" <ecs@.netset.com> wrote in message
news:uNziNjmEEHA.2768@.tk2msftngp13.phx.gbl...
> Anyone else like to comment. If this can not be done what would be the
best
> and easiest way to move
> like 50 databases off of EE onto a standard version of MS SQL?
>|||Thanks mike,
any websites to point us to for scripting the sql server logins?|||I don't have any links for you, but I'm sure there are several places that
have this info. I think you can use DTS also, though I haven't done that
myself
Here's what I use. Run these on the old system, and results of each
statement is a script you run on the new system. They can be easily modified
to include a GO between each statement, otherwise you have to run each line
individually.
--For SQL logins
SELECT 'sp_addlogin '''+
left(name + ''', ',15), --Adjust for max login length
password,
+ ', ''' +
db_name(dbid) +
+ ''', ''' +
+ language
+ ''', ',
sid,
', skip_encryption'
FROM master.dbo.sysxlogins
where srvid is null
and xstatus&4 <> 4 --isntname
order by name
--For Windows logins
SELECT 'sp_grantlogin '''+ name + ''''
FROM master.dbo.sysxlogins
where srvid is null
and xstatus&4 = 4 --isntname
and name <> 'BUILTIN\ADMINISTRATORS'
order by name
"ECS" <xxxx@.xx.com> wrote in message
news:uvyjrhqEEHA.3392@.TK2MSFTNGP11.phx.gbl...
> Thanks mike,
> any websites to point us to for scripting the sql server logins?
>