I am in the process of designing a daily partitioned cube where each
partition should hold some half a milion records.
Cube also contain some 12 dimensions and that number may grow.
Are you aware of any guidelines i should follow to ensure cube is
stable and efficient?
I am using 32bit 2003 sp2 server with 32 GB RAM.
SSAS 2005 sp3.
I have already trouble processing (incrementaly) another smaller daily cube.
How can i allow ssas consume more RAM then its default settings?
As for quries perforemance are there any guidelines on top of
fine tuning aggregations usage and upgrading server to 64bit?
View Complete Post