PRB: Memory Error When Loading Large Dimensions (303370)


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
  • Microsoft SQL Server OLAP Services 7.0
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:
"Memory error [Failed to reallocate space]".
The application event log shows the following error:
"The server is out of memory"

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.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb KB303370
©2004 Microsoft Corporation. All rights reserved.