àÎ Á Ìå ÄÚ æ íÎó

´´½¨¶àÎ¬Á¢·½Ìå£¬±¨ÄÚ´æ´íÎó£¡£¡

POPULAR GROUPS

more...

microsoft.public.cn.sqlserver Profile…

´´½¨¶àÎ¬Á¢·½Ìå£¬±¨ÄÚ´æ´íÎó£¡£¡

Author: fan
Date: Jul 21, 2008 03:16

²Ù×÷ÏµÍ³:windows server2003
Êý¾Ý¿âÏµÍ³:SQL Server 2005 Standard Edition (SP2)
Ó²¼þ:IBM ·þÎñÆ÷,ÎïÀí2cup,Âß¼2cup£¬4GÄÚ´æ£¬ÐéÄâ2G
ÎÊÌâ1:ÔÚAnalysis services 2005 ´¦ÀíCUBE»òÕßÎ¬¶ÈµÄÊ±ºò, Ò»µ©msmdsrv.exe ½ø³ÌÕ¼ÓÃÄÚ´æ³¬¹ý1.8G×óÓÒ,¾Í»á±¨´í(ÄÚ´æ´íÎó: ·ÖÅäÊ§°Ü : ´æ´¢¿Õ¼ä²»×ã£¬ÎÞ·¨´¦Àí´ËÃüÁî¡£ ¡£),¿ÉÊµ¼Ê¿ÉÊ¹ÓÃ
ÄÚ´æ²¢²»Ö¹ÕâÃ´¶à,²¢ÇÒ,Ò»µ©Æô¶¯Analysis services 2005 ¹ÜÀí½çÃæ,ÄÚ´æ¾ÍÒ»Ö±Õ¼ÓÃ,ÎÞ·¨ÊÍ·Å,Ö»ÓÐÖØÆð·þÎñ²ÅÊÍ·Å,ÕâÓÐÊ²Ã´·½·¨ÄÜ½â¾ö?
ÎÊÌâ2:¿´¹ýSQL Server 2005 µÄAWE¶¯Ì¬ÄÚ´æ,ÕâÊÇ·ñÊÊºÏÓÚAnalysis services 2005 ,»¹ÊÇÖ»ÊÇÕë¶ÔÓÚSQL Server 2005 µÄÊý¾ÝÒýÇæ?

1 Comment

RE: 创建多维立方体，报内存错误！！

Author: RM
Date: Jul 21, 2008 10:21

SSAS can't use memory above 2gb range on 32-bit machine, so there is no awe
for it. Possible to move to 64-bit?

"fan" wrote:

> 操作系统:windows server2003
> 数据库系统:SQL Server 2005 Standard Edition (SP2)
> 硬件:IBM 服务器,物理2cup,逻辑2cup，4G内存，虚拟2G
> 问题1:在Analysis services 2005 处理CUBE或者维度的时候, 一旦msmdsrv.exe 进程占用内存超过1.8G左右,就会报错(内存错误: 分配失败 : 存储空间不足，无法处理此命令。。),可实际可使用
> 内存并不止这么多,并且,一旦启动Analysis services 2005 管理界面,内存就一直占用,无法释放,只有重起服务才释放,这有什么方法能解决?
> 问题2:看过SQL Server 2005 的AWE动态内存,这是否适合于Analysis services 2005 ,还是只是针对于SQL Server 2005 的数据引擎?
>
>
>

no comments