paging file is too small during processing cube

[stanja]

Hello ,

During the processing of a cube i receive the error message '-1056767999,0x,Memory error: Allocation failure : The paging file is too small for this operation to complete'
The OS (win 2003 ) page file size is 2.5GB and there's enough diskspace.
Can i verify or change settings in order to get the cube build ?
Any help would be grate

tx
regards
Stanja

 

[mrdenny]

Have you tried the obvious, increasing the size of the page file?

How much RAM do you have?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[MDXer]

is this SQL 2K AS or 2005 SSAS?

If 2005 SSAS you can reduce the number of items being processed in parallel.

In any case you probably need more RAM.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[stanja]

we've got 8GB RAM , SQL srvr 2005.
I've added the /3GB parameter in the boot.ini but still need to reboot the server .
I 've to wait till tomorrow to see the result