SSIS 设计器运行非常缓慢 [英] SSIS Designer is running VERY slowly

问题描述

我正在开发 SQL Server 集成服务包.我一直在对这个包进行一些重大的重构，现在设计器的运行速度非常慢.即使在屏幕周围移动组件也会导致设计人员挂起 2-3 分钟.查看任务管理器 Visual Studio 在此期间消耗了大约 80% 的 CPU.

I am developing an SQL Server Integration Services package. I have been doing some major refactoring to this package, and now the designer is running really slowly. Even moving components around the screen causes the designer to hang for 2-3 minutes. Looking at the task manager Visual Studio is consuming around 80% of the CPU during this period.

有人对这种缓慢的性能有什么想法吗?

Does anyone have any ideas about this slow performance?

推荐答案

你的包有多大?您是否尝试在单个包中执行整个 ETL?

How big is your package? Are you attempting to perform a whole ETL in a single package?

它有助于保持您的包较小，并在主包中管理编排.

It helps to keep your packages small, and manage the orchestration in a master package.

这也有助于 SCC.

要从另一个包调用一个包，标准方法是使用工具箱中的执行包任务".但是，对于非常大的包集，这也会变得很麻烦，而且使用 NAnt/MSbuild 来管理编排会变得更容易.

To call one package from another, the standard way is to use an "Execute Package Task" from the toolbox. However, with very large sets of packages this too can become cumbersome and it can become easier to use NAnt/MSbuild to manage the orchestration.

这篇关于SSIS 设计器运行非常缓慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！