How can I determine what hardware and software resources my SQL Server 2000 Analysis Services instance requires?
First, because Analysis Services 2000 loads all dimension members and their member properties into memory at startup, and also loads a copy of this dimension information into memory during dimension processing, your hardware platform must support sufficient memory address space for these dimension members and their properties. In addition, if you're using dimension-b...