Article ID: 295443 - View products that this article applies to.
This article was previously published under Q295443
This article has been archived. It is offered "as is" and will no longer be updated.
By default, the Analysis Server process is limited to 2 gigabytes (GB) of RAM, unless Application Memory Tuning is enabled. This article describes how to enable Analysis Server to use more than 2 GB of RAM.
By default, the Analysis Server process is limited to 2 GB of RAM, unless Application Memory Tuning is enabled. However, you can only enable Application Memory Tuning on a Microsoft Windows NT 4.0 Enterprise Edition or Microsoft Windows 2000 Advanced Server-based computer. With Application Memory Tuning enabled, the OLAP Server process can use 3 GB of memory.
If Analysis Server is running on the Standard version of Microsoft Windows NT 4.0 Server or Microsoft Windows 2000 Server, you cannot enable Application Memory Tuning. When Analysis Server is run with the Standard version of Microsoft Windows NT 4.0 Server or Microsoft Windows 2000 Server, the Analysis Server process is limited to 2 GB of memory. To enable Application Memory Tuning, modify the Boot.ini file, and then add the /3GB parameter to the ARC path. Here is an example of a Boot.ini file with the /3GB parameter added:
For additional information about Application Memory Tuning, click the article number below to view the article in the Microsoft Knowledge Base:
[boot loader] timeout=30 default=multi(0)disk(0)rdisk(0)partition(1)\WINNT [operating systems] multi(0)disk(0)rdisk(0)partition(1)\WINNT = "Windows 2000 Advanced Server" /fastdetect /3GB multi(0)disk(0)rdisk(0)partition(1)\WINNT = "NT 4.0 Server Enterprise Edition" /fastdetect /3GB
171793After you enable Application Memory Tuning, you must instruct Analysis Services to use the additional memory, because Analysis Services does not detect that additional memory is available.
(http://support.microsoft.com/kb/171793/EN-US/ )Information on Application Use of 4GT RAM Tuning
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
To enable Analysis Services to use 3 GB of RAM, after you enable Application Memory Tuning, follow these steps:
Valid values are whole numbers from 1 to 2,047.
When this occurs, you must either cancel the operation or set the Memory Conservation Threshold property to a value that is in the range of 1 to 2,047.
With Analysis Services Service Pack 3, you can change memory usage above 2,047 MB by using the Memory Conservation Threshold property. To do this, follow these steps:
(http://support.microsoft.com/kb/823357/ )PRB: Connection to Analysis Services Fails After You Install Analysis Services Service Pack 3
Article ID: 295443 - Last Review: February 27, 2014 - Revision: 5.5
Contact us for more help
Connect with Answer Desk for expert help.