|
|
|
Ошибка с MS Analisys Service 2000
|
|||
|---|---|---|---|
|
#18+
Доброго всем дня! Столкнулся с проблемой. При процессировании куба выдается сообщение Analysis Server Error: Memory error [Failed to reallocate space] '' ; В Event View-Application ошибка: Source MSSQLServerOLAPService The server is out of memory. В настройках сервера MSAS изменил настройки памяти, максимум 2500 МБ перестартовал Процесс занимает 1600 Мб Физически доступно 970Мб В чем может быть проблема? Спасибо ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.10.2008, 16:52 |
|
||
|
Ошибка с MS Analisys Service 2000
|
|||
|---|---|---|---|
|
#18+
Win2003 SP2 Analysis Server 2000 SP4 ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 24.10.2008, 16:56 |
|
||
|
Ошибка с MS Analisys Service 2000
|
|||
|---|---|---|---|
|
#18+
Та же самая проблема. Только Win2003 SP2 и Analysis Server 2000 SP4 уже стоят. Сначала MSAS зависал при процессинге, кидая в Event Log сообщение автор"The memory conservation threshold was exceeded by more than 12.5 percent for an extended period." Поискали, нашли - авторTo improve Microsoft Analysis Services performance: NOTES: You should upgrade to Analysis Services SP4. The Trend Analysis Server requires a minimum 2GB of RAM. 1.Go to folder \Program Files\Microsoft Analysis Services\Bin. 1.Rename msmdvldm.exe so that Analysis Services cannot use the file. 2.On the trend analysis central computer, click Programs > Microsoft SQL Server > Analysis Services > Analysis Manager. 3.Expand Console Root > Analysis Servers. 4.Right-click on the server name. 5.Click Properties. 6.Select the Processing tab. 7.Change Process Buffer Size to 200 MB from the default value of 32 MB. 8.Select the Environment tab. 9.Change Memory Conservation Threshold to a value between a minimum of 1024 and a maximum of, physical memory on the server minus 1024 MB, but not to exceed the following: If the /3GB switch is NOT set in the Windows C:\boot.ini, the maximum setting should be 1650 MB. If the /3GB switch IS set in the Windows C:\boot.ini, the maximum setting should be 2650 MB. 10.Change Minimum Allocation Memory to be 1024 MB. 11.Click OK. 12.Change the OLAP registry setting below as referenced from Microsoft KB823357 Click Start, and then click Run. Type regedit, and then click OK. Locate the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion In the right pane, double-click HighMemoryLimit. In the Edit DWORD Value dialog box, click Decimal. In the Value data box, type a value that is the same as the value from step 10 in bytes (i.e. if you have 1024 for step 10, then you would put in 1024x1048576 or 1073741824) Quit Registry Editor. 13.Restart the MSSQLServerOLAPService. For more information about getting better performance from Analysis Services http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx. For information about How To Enable Analysis Server to Use 3 GB of RAM http://support.microsoft.com/kb/295443/en-us For more information about Trend Analysis problems, see: http://support.microsoft.com/kb/823357/en-us Все сделал, но теперь - авторThe server is out of memory. Что еще подлечить? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 31.07.2009, 16:37 |
|
||
|
Ошибка с MS Analisys Service 2000
|
|||
|---|---|---|---|
|
#18+
Да, забыл - в boot.ini поставил /3GB, а Memory Conservation Threshold = 2650 Всего на сервере - 6 гигов RAM ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 31.07.2009, 16:44 |
|
||
|
|

start [/forum/topic.php?fid=31&msg=35615144&tid=1536030]: |
0ms |
get settings: |
10ms |
get forum list: |
16ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
165ms |
get topic data: |
14ms |
get forum data: |
3ms |
get page messages: |
56ms |
get tp. blocked users: |
1ms |
| others: | 251ms |
| total: | 522ms |

| 0 / 0 |
