Error 123

最新推荐文章于 2024-01-09 08:00:00 发布

michaelgy

最新推荐文章于 2024-01-09 08:00:00 发布

阅读量1.1k

点赞数

文章标签： microsoft server sql server windows properties processing

本文链接：https://blog.csdn.net/michaelgy/article/details/1779068

版权

Troubleshooting (SQL Server 2000)

Error 123

The server is out of memory.%0

Analysis Services load all dimensions for all databases into volatile memory on startup. During processing, the server consumes additional memory to process updates to dimensions and cubes. If insufficient memory is available for these and other operations, you will receive this message.

You can resolve this issue in several ways:

Using Microsoft Windows® NT 4.0 Enterprise Edition, Windows 2000 Advanced Server, or Windows 2000 Datacenter Server, enable application memory tuning and then enable the Analysis server to use 3 gigabytes (GB) of RAM. For more information, see Microsoft Knowledge Base article 295443, How To Enable Analysis Services to Use 3 GB of RAM.
Lower the HighMemoryLimit registry entry, so that the cleaner thread starts earlier. For more information on this, and other registry entries mentioned in this topic, see this Microsoft Web site.
Lower the BackgroundInterval registry entry, so that background operations are performed more frequently.
Lower the ProcessReadAheadSize, ProcessReadSegmentSize, and ProcessRecordsReportGranularity registry entries to reduce the amount of memory used during processing.
Increase the page file size or create a second page file.

If dimensions are too large to fit in memory, the following changes may be required:

Install more physical memory in the server.
Upgrade to a 64-bit platform.
Reduce the size of the dimension as follows:
1. Convert the dimension keys to integers.
2. Eliminate any unnecessary redundant data elements.
3. Delete or reduce the number of member properties used in dimensions.
Convert to ROLAP storage.