It could be that it's loading the dimension members into memory. Watch the
memory utlization by the server process from task manager and see if it
continually rises while starting. If it does, then that's a strong
indication it's loading dimension members.

Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Paulo Andre Ortega Ribeiro" <paulo.andre.66@terra.com.br> wrote in message
news:%23$x6oXbkDHA.2312@TK2MSFTNGP12.phx.gbl...
> Sometime is necessary to stop MSSQLSeverOLAPServieces to do a full
> backup in my OLAP Server disks. After backup had finished and I tried to
> star MSSQLSeverOLAPServieces but it takes almost 30 minutes to the
> services starts.
> What can it be causing that?
>
> Paulo
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>

Yes, memory utlization by the server process continually rises while
starting. Is it a problem? Can I avoid that?

Paulo



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Paulo,

You may not be able to avoid it. Analysis Services loads all dimension
members into memory as the service starts. I'd make sure that you have
enough physical RAM on the box to handle this many members. If you don't,
and are paging, I could see why it would take that long to start.

If you have any large dimensions like Customer or Order, you may need to
consider using drill-through to expose data at this level of granularity or
use actions.

Sean


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Paulo Andre Ortega Ribeiro" <paulo.andre.66@terra.com.br> wrote in message
news:%23idsU8kkDHA.3312@tk2msftngp13.phx.gbl...
> Yes, memory utlization by the server process continually rises while
> starting. Is it a problem? Can I avoid that?
>
> Paulo
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!