| Vladimir Chtepa 2006-03-30, 3:26 am |
| Thank your Dave,
Do you want to say, that there isn't predictable way to determinay if the
procesing of the whole database will failed?
Where could I get the cmdline XMLA utility?
Thanks in advance
Vladimir Chtepa
"Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
news:eK1Cmj4UGHA.4348@TK2MSFTNGP09.phx.gbl...
> Depending on other uses of memory, it may not be possible to process large
> dimensions on a 32-bit server. We have found that with Project REAL, we
> are right on the boundary line between being able to process it or not.
> Some of the tricks you can do to minimize the use of memory are: (1) as
> you found, process either object by object or groups of objects; (2) for
> partitions that use large dimensions, it can help significantly if you
> first do a ProcessData and then a ProcessIndex; (3) do a service restart
> before you start processing (kind of brute force but does work); and (4)
> issue ClearCache XMLA commands to free up the data cache, see attached
>
> You can automate the reprocessing of objects using XMLA scripting (as part
> of Project REAL we've developed a command-line utility to execute XMLA
> scripts.
>
> --
> Dave Wickert [MSFT]
> dwickert@online.microsoft.com
> Program Manager
> BI Systems Team
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> "Vladimir Chtepa" <chtepa._nosmap.@t-online.nosmap.de> wrote in message
> news:en6mPIqUGHA.2444@TK2MSFTNGP14.phx.gbl...
>
>
>
|