SSIS包性能。 [英] SSIS Package performance.

问题描述

SSIS中常见的面试问题。

Commonly asked interview question in SSIS.

1）我的软件包在开发中运行速度很快但非常生产缓慢。会是什么原因？开发和生产DB都具有相同的数据，但它在开发中需要10秒，但在生产中需要10分钟。为什么？

1) My package is running fast in dev but it is very slow in Production. What will be the reason? Both dev and production DB having same data but it is taking 10 sec in dev but taking 10 mins in production. why?

有人可以告诉我这个性能落后的可能性有多大？

can someone please let me know What are all the possibilities for this performance lagging?

TIA。

Aravinth

推荐答案

>>>这有什么可能性性能滞后？

DEV和PROD在CPU，内存，IO方面是否相同？

包裹是什么？加载数据？

https://stackoverflow.com/questions/2678119/is-there-a-reason-why-ssis-significantly-slows-几分钟后

https://stackoverflow.com/questions/2678119/is-there-a-reason-why-ssis-significantly-slows-down-after-a-few-minutes

这篇关于SSIS包性能。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！