Microsoft KB Archive/303370

= PRB: Memory Error When Loading Large Dimensions =

Article ID: 303370

Article Last Modified on 10/26/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft SQL Server OLAP Services

-



This article was previously published under Q303370



SYMPTOMS
When Microsoft SQL Server 2000 Analysis Services or Microsoft SQL Server OLAP Services attempts to load a large amount of dimension data, the following error may be displayed:

&quot;Memory error [Failed to reallocate space]&quot;.

The application event log shows the following error:

&quot;The server is out of memory&quot;



CAUSE
The default or current pagefile is too small to handle the task.



WORKAROUND
You can resolve the problem in the following ways:
 * Expand the default pagefile to its maximum size on the system disk (typically drive C).
 * Add a pagefile on a second disk with the same amount of physical memory as is on the system.



MORE INFORMATION
To check the size of your pagefile on Microsoft Windows 2000, follow these steps:
 * 1) On the desktop, right-click the My Computer icon and click Properties.
 * 2) Click the Advanced tab and then click Performance Options.
 * 3) Under the Virtual Memory section, click the Change button. A dialog box displays the amount of disk space that is reserved for your pagefile.

Additional query words: OLAP RAM VIRTUAL MEMORY SWAP

Keywords: kbproductlink kbprb KB303370

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.