I am using Win2003 with SP2 + SQL 2K5 with SP2. I verified MSXML core service 6.0 and OLE DB9.0 is installed and registered.

Following http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/cisql2005ascs.mspx, I double checked...

After I updated the SQL Server to SP2 and changed the memory from 2G to /3G, it became much better now. The next plan might be to update OS to...

OLAP service still runs out of memory after I install SQL Server SP2. But cubes can be accessed when the service is out of memory (they are not accessible before...

I changed it and also changed the page file size to 8092M (min and Max are same). But it does not work. The msmdsrv.exe consumes about 2900M memory when I...

I found the root cause just now. The reason is I replaced Process option from ProcessFull to ProcessDefault when I updated the XMLA.

🙂

Thanks so much.

Huasheng