ssas - SSAS 表格 - 我创建的度量越多，Visual Studio 创建新度量所需的时间就越多

Question

实际上我的问题是：我创建的度量值越多，Visual Studio 创建新度量值所需的时间就越多。（Visual Studio 保持不响应）

这些措施并不是很复杂，但实际上创建一个新措施需要三十秒~一分钟（实际上我有大约 50-100 个措施）。

我实际上拥有的临时解决方案是在代码页中创建度量，但我想知道 ssas 表格的可伸缩性是否必须再次创建 100 个度量。

-我的记忆：16 Go，2,60GhZ i7。- 事实表中的数据约为 5 万行。-我没有打开其他项目。-SQL server 2016，SQL Server 有最新的 build 2020-09-28 (build : 13.0.5850.14)。-我没有构建操作，也没有将数据备份到磁盘。

我想知道视觉工作室在创建每个度量之间需要一些时间是否正常。

如果您有一些提示或建议，请不要犹豫分享:) 也许我应该尝试按事实表拆分我的度量，而不是在一个度量表中创建？也许我可以尝试更改一些参数？

标签： ssasdaxtabularmeasure

Answer 1

Depending on a lot of things, like how the data looks (not only the number of rows in the fact table, but size etc), the hardware, network etc, I would say it's not very rare to experience some delays and slowness working with SSAS in visual studio when it starts loading data into the grids in the designer. As someone mentioned in the comments, there are third party alternatives for editing tabular models that doesn't have this behavior/functionality.

However, if you still want to use visual studio there are ways to possibly get around this. For example if you have a dedicated server/database for development purposes, where you have views as sources for the tables in the tabular model, you can add a TOP condition to the SELECT statement in the views to eliminate/limit the data loaded into visual studio during development.