When you use the OLE DB for OLAP provider in Microsoft SQL Server 2000 Analysis Services, physical memory usage increases for multithreaded applications. Physical memory usage increases as the number of threads that are using the provider increases.
Read More - Register for Free Membership