All:

I was wondering if anyone has attempted to stop Analysis Services from
pre-loading all Shared Dimensions (and Priate Dimensions, for that matter)
upon server start. I heard somewhere, that there is an obscure property that
controls this behavior...

Any ideas?

TIA,

MTI

All dimensions are loaded into memory when the service starts up. There is
no property that allows you to configure this otherwise.

If you find that you still need more memory, the 64-bit edition of Analysis
Services can utilize more than 3GB of address space.


--
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.


Sean


"Michael Thompson Isaac" <mti@xbagroup_dot_com> wrote