Good morning,
when I start the service MSSQLServerOLAPService,
it starts approximately in 1 minute, while before it was faster.
Which could be the possible causes ?
Thanks

My initial guess is that it is building the in-memory structures for
dimensions.
If you have recently increased the number of members in one or more of your
dimensionsm this could account for the longer startup time. Look at the
memory usage sections in the Performance and Operations Guides pointed to
from this page:
http://www.microsoft.com/sql/evaluat...bianalysis.asp

Hope this helps.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Mathasu78" <wendynet (AT) libero (DOT) it> wrote

All dimensions from all databases are loaded into memory when olap service
is started.

public @ the domain below
www.tomchester.net

"Mathasu78" <wendynet (AT) libero (DOT) it> wrote