如何让SSAS使用更多内存 [英] How to get SSAS to Use More Memory

问题描述

我正在尝试处理正在处理来自不同服务器的数据的开发服务器上的多维数据集。这个过程花了很长时间才第一次运行所以我认为这部分是因为开发服务器上只有4 GB的RAM。所以，我把它提高到了
，最高可达20 GB，希望看到性能有所改善。

但是，当我选中"perfmon"时我注意到总内存使用量不会超过4 GB RAM，即使我现在有20 GB。

如何让SSAS使用更多RAM？ 安装RAM后我应该做些什么？

我知道它已得到认可，整个计算机实际上工作得更好。

一些信息：

1. 
   SQL Server版本：Microsoft SQL Server 2014（SP2）（KB3171021） - 12.0.5000.0（X64）Developer Edition（64位）在Windows NT 6.1上（Build 7601：Service）包1）
2. 
   

   
   Windows版本：Windows 7专业版64位

   
   
3. 
   

   
   Visual Studio版本：社区2015

   
   

这是内存使用情况的屏幕截图。此时，它正在运行的当前步骤是"处理
分区'MyCube' - 进行中 - 450000 of 100。"

这是SSAS服务器设置的屏幕截图：

解决方案

您如何知道您的SSAS进程需要的内存超过4GB？具体工作负载需求可能会给磁盘或CPU等其他子系统带来更多负担。

安装额外的RAM后重新启动SSAS服务吗？

HTH，

I'm trying to process a cube on a development server which is processing data from a different server. The process took a long time to run the first time so I figured it was partially because the development server only had 4 GB of RAM on it. So, I bumped it up to 20 GB of RAM hoping to see some improvement in performance.

However, when I checked "perfmon" I noticed that total memory usage would not go beyond 4 GB of RAM even though I now have 20 GB.

How do I get SSAS do use more RAM? Something else I should do after installing RAM?

I know it's recognized and the computer as a whole is actually working better.

Some info:

1. SQL Server version: Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Developer Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

2. Windows version: Windows 7 pro 64-bit

3. Visual Studio version: Community 2015

Here's a screen shot of the memory usage. At this time, the current step it's running is "Processing Partition 'MyCube' - In Progress - 450000 of 100."

Here's a screen shot of the SSAS Server settings:

解决方案

How do you know your SSAS processes are needing more memory than 4GB? The specific workload demands may be placing more burden on other subsystems like disk or CPU.

Did you restart SSAS Service after installing the additional RAM?

HTH,

这篇关于如何让SSAS使用更多内存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！